Adding logic in hidden columns is a core implementation mechanism in Coda - they’re almost like real-time function calls that operate on each row whenever something changes. They’re incredibly powerful.
Take a look at this truly excellent Work Breakdown Structure project for example. See how many hidden columns there are and how they’re used…