Formula Suggestions

Jshah

I have to apply different calculations to certain columns, and after changes from the department, I'll have to modify the formula. How can I make this situation work? Is it possible to use two different formulas in the same column?

Thank you in advance!

Matt Johnson

Hi @Jshah

Do you have any other information you can share? If not, I would suggest helper columns and nested IF statements.

For example: IF columnA is blank, use the value from columnB, if not, use the value from columnA. Maybe something like that could work.

I hope that helps.

Matt