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

• ✭✭✭✭✭✭

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

• ✭✭✭✭✭✭

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

• Thank you !

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!