Question with Symbol Formulas

Ronnie D.

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"))))

Kelly Moore

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

Kelly Moore

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

Ronnie D.

Thank you !