Question with Symbol Formulas

Hello,

I am trying to get my formula to return the Gray symbol if the date is blank. Any assistance would be of immense help.


=IF([OSHA-30 Exp Date (7-yr)]@row - TODAY() > 75, "Green", IF([OSHA-30 Exp Date (7-yr)]@row < TODAY(), "Red", "Yellow", OR(IFBLANK([OSHA-30 Exp Date (7-yr)]@row - "Gray"))))

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    Hey @Ronnie D.

    Does this give you what you are expecting?

    =IF(ISBLANK([OSHA-30 Exp Date (7-yr)]@row), "Gray", IF([OSHA-30 Exp Date (7-yr)]@row - TODAY() > 75, "Green", IF([OSHA-30 Exp Date (7-yr)]@row < TODAY(), "Red", "Yellow")))

    cheers

    Kelly

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!