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"))))
Comments
-
Do you need one filled in and the other can be blank, or do both need to be populated?
-
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?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!