How to combine two formulas

Corin
Corin ✭✭✭
in Formulas and Functions

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?

· Share on FacebookShare on Twitter

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)

    · Share on FacebookShare on Twitter

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)

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!