Helper columns

Esperanza Zagal

Hi there,

Is there a tutorial on helper columns? Helper columns have been suggested to me, and I'm sure they will help our group but I am still confused on how to use them.

Thank you!

Esperanza

John Jonassen

No need for a tutorial. Helper columns are whatever you need to break down some formulas or provide some work arounds. Example, I have a helper column that is an IF statement that will say "YES" if the row meets a series of criteria or "NO" if it doesn't. Then a column next to that will only calculate if the helper column states "YES".

Does that help simplify?

John Jonassen

No need for a tutorial. Helper columns are whatever you need to break down some formulas or provide some work arounds. Example, I have a helper column that is an IF statement that will say "YES" if the row meets a series of criteria or "NO" if it doesn't. Then a column next to that will only calculate if the helper column states "YES".

Does that help simplify?

Esperanza Zagal

It does!

Thank you,

Esperanza