Embedding IFERROR into an existing formula

Sarah Thompson
edited 12/09/19 in Formulas and Functions

I need some help as to how to embed an IFERROR function into this formula: 

=IF([Group Contract Anticipated]438 = 0, "Gray", IF(ISBLANK([Deposit Due Date]438), "Gray", IF(ISDATE([Deposit Sent]438), "Green", IF(TODAY() - [Deposit Due Date]438 <= -10, "Green", IF(TODAY() - [Deposit Due Date]438 > -7, "Red", IF(TODAY() - [Deposit Due Date]438 > -10, "Yellow"))))))

Someone could put N/A in one of those columns and it comes up as an invalid value, when it's actually fine. I want it to display N/A. 

I'm not 100% sure if IFERROR is even the right function to use. Any help would be appreciated!

-Sarah

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!