Formula Suggestions

Jshah ✭✭
edited 02/07/23 in Formulas and Functions

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
    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 Johnson

    Sevan Technology

    Smartsheet Aligned Partner

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!