IF Error needed????

it works if there is data in the fields but if the fields are blank - it gives me the #incorrect argument

=IF([*DEPLOYED Y/N/Daytime]564 = "Yes", "Green", IF(AND([*DEPLOYED Y/N/Daytime]564 <> "No", TODAY() < [*Scheduled Deployment Date]564, "Red", IF(AND([*DEPLOYED Y/N/Daytime]564 = "Daytime Deployment"), "Yellow"))))

Find more posts tagged with

Formulas

Comments

Paul Newcome

Do you need one filled in and the other can be blank, or do both need to be populated?

Mike Wilday

You could wrap the entire formula in an IFERROR...

=IFERROR(IF([*DEPLOYED Y/N/Daytime]564 = "Yes", "Green", IF(AND([*DEPLOYED Y/N/Daytime]564 <> "No", TODAY() < [*Scheduled Deployment Date]564, "Red", IF(AND([*DEPLOYED Y/N/Daytime]564 = "Daytime Deployment"), "Yellow")))),"BLANK FIELDS")

This would alert you that there are blank fields in the row rather than send you an #error message. You could also remove the words Blank Fields to just leave the field blank.

Did that work?

Sign in to join the conversation!

Quick Links

Trending discussions

Circular Reference with formula
i am not good with writing formulas within a sheet. I asked the AI tool in the sheet to help me write a formula and I am getting a Circular reference back. I'm trying to have it write the following formula for me. If the column "Tracking #" is not blank, change Column "Deployment Phase" to "Shipped" I have tried adding in…
How to delay the execution of a workflow whose trigger occurred much earlier?
I have a workflow that detects a row(date) that is changing its Fiscal Week Finish Date and send this row to other Sheet. Long story short: I collect delayed tasks in separate file & I tag reasons for delay for these tasks. It happens that plan are analyzed 2-3 hours and dates are being changed several times. I would like…
INDEX/COLLECT??
Having trouble with an INDEX/COLLECT/CONTAINS formula. I have two sheets, my source and my destination; the source sheet has a column I want to collect into the destination. -Tool ID, is in both sheets and the target of the INDEX/MATCH, the source sheet might have this listed 6 or 7 times -Purpose of Device, there are…