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

Find more posts tagged with

Formulas

Support

Comments

Brian W

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

Mike Wilday

Would you want N/A to be gray or empty?

Sarah Thompson

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.

Sarah Thompson

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.