Make formula writing easier and your documents faster

Make formula writing easier and your documents faster

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:

Easier to write

Easier to debug

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