How to combine two formulas

I have an Aging column (start date-Today) and once my Health Status G/Y/R/C column= C, I need the aging to stop. What formula would I use for this?

Best Answer

  • Jason Duryea
    Jason Duryea ✭✭✭✭✭✭
    Answer ✓

    If the Health Status is "C" you would need to base the formula on a non-variable date like Finish Date. For example:

    =IF([Health Status]@row = C, [Start Date]@row - [Finish Date]@row, [Start Date]@row - Today)

Answers

  • Jason Duryea
    Jason Duryea ✭✭✭✭✭✭
    Answer ✓

    If the Health Status is "C" you would need to base the formula on a non-variable date like Finish Date. For example:

    =IF([Health Status]@row = C, [Start Date]@row - [Finish Date]@row, [Start Date]@row - Today)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!