Adding N/A as a dropdown so that it doesn't display 'Invalid'


Good day,

I want to add not applicable as 'N/A' on a dropdown to this formula such that it doesn't display 'INVALID'. Grateful for any help.

=IFERROR(IF(ISBLANK([Expiry Date]@row), "", IF([Expiry Date]@row <= TODAY(), "Red", IF([Expiry Date]@row <= TODAY(90), "Yellow", IF([Expiry Date]@row > TODAY(90), "Green")))), "")

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!