Embedding IFERROR into an existing formula
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
-
Hi Sarah.Try this:
=IFERROR(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")))))),"N/A")
-
Would you want N/A to be gray or empty?
-
I would like N/A to actually say N/A. I don't know if you can do that in one of those RYGG columns, though. I guess I would prefer it to be gray if I had to choose.
-
That worked. Thank you. Sometimes I have an issue with the order of operations in these formulas. I never really used them in Excel so Smartsheet is basically my first exposure to them.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!