IF/AND Statements to change Symbol colors
I have a column in an equipment check-in/out sheet with Symbols (Red, Yellow, Green, Blue) where I am attempting an IF/AND statement to determine the color.
Yellow = OUT box is checked and the date is today
Red = OUT box is checked and the date is before today
Green = IN box is checked
Blue = Maint box is checked
Each individual formula works but when I put them all together, I receive an INCORRECT ARGUMENT.
Individual formulas:
=IF(AND(OUT@row = 1, [Due Date]@row = TODAY()), "Yellow")
IF(AND(OUT@row = 1, [Due Date]@row < TODAY()), “Red”
IF(IN@row = 1, "Green"
IF(Maint@row = 1, "Blue"
Formulas parsed together:
=IF(IN@row = 1, "Green", IF(Maint@row = 1, "Blue", IF(AND(OUT@row = 1, [Due Date]@row < TODAY(), "Red", IF(AND(OUT@row = TODAY(), "Yellow"))))))
Any assistance would be appreciated.
Best Answers
-
Hello @tschlitz
If that is your formula you are missing 2 ")"
=IF(IN@row = 1, "Green", IF(Maint@row = 1, "Blue", IF(AND(OUT@row = 1, [Due Date]@row < TODAY()), "Red", IF(AND(OUT@row = TODAY()), "Yellow"))))))
-
That worked! thank you!!
Answers
-
Hello @tschlitz
If that is your formula you are missing 2 ")"
=IF(IN@row = 1, "Green", IF(Maint@row = 1, "Blue", IF(AND(OUT@row = 1, [Due Date]@row < TODAY()), "Red", IF(AND(OUT@row = TODAY()), "Yellow"))))))
-
That worked! thank you!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!