It is very common for formulas in your tables to become long. Or you might find yourself needing to write a particularly complex formula that you are struggling to make work. This is where formula segmenting can really begin to help.
Segmenting your formulas across columns has the following benefits:
Actually faster for your docs and tables! Segmenting your formulas is where you write formulas in small chunks in separate columns, rather than writing one large formula in a single column Take for example the table below.
A non-segmented formula
The formula that is written in the gray column is a longer and harder to understand and de-bug formula that pulls all the vowels out of the first half of a persons email.
A segmented formula
The blue columns demonstrate how to segment this same formula across multiple columns. Segmenting in this way makes the formula easier to understand, write, de-bug, and makes your doc faster in the long run
All vowels in first half of an email address
Ready to master Coda yourself?
Join the Coda School today