IF, AND/OR, NOT formula with multiple conditions for a symbol column
Hello,
I have been using a symbol column to monitor updates for a master sheet of all of my departments projects: =IF([Exec Summary Update]@row < TODAY(-14), "Red", IF([Exec Summary Update]@row < TODAY(-8), "Yellow", "Green"))
However, I need to update this formula to include criteria that states NOT if the Phase@row is blank or "Closed"
I obviously can't figure out the proper syntax to insert into my formula as I keep getting #Incorrect Argument Set error messages.
If anyone could help me update my formula, that would be awesome!
Best Answer
-
I've split the answer into 3 steps to make it clear to anyone following along (but I don't think you need anything except the last part).
1.
This formula will put nothing into your symbol column if Phase is "Closed"
=IF(Phase@row = "Closed", "", IF([Exec Summary Update]@row < TODAY(-14), "Red", IF([Exec Summary Update]@row < TODAY(-8), "Yellow", "Green")))
Here it is in context
2.
This formula will put nothing into your symbol column if Phase is blank
=IF(ISBLANK(Phase@row), "", IF([Exec Summary Update]@row < TODAY(-14), "Red", IF([Exec Summary Update]@row < TODAY(-8), "Yellow", "Green")))
3.
To combine both of these logics use
=IF(OR(ISBLANK(Phase@row), Phase@row = "Closed"), "", IF([Exec Summary Update]@row < TODAY(-14), "Red", IF([Exec Summary Update]@row < TODAY(-8), "Yellow", "Green")))
Answers
-
I've split the answer into 3 steps to make it clear to anyone following along (but I don't think you need anything except the last part).
1.
This formula will put nothing into your symbol column if Phase is "Closed"
=IF(Phase@row = "Closed", "", IF([Exec Summary Update]@row < TODAY(-14), "Red", IF([Exec Summary Update]@row < TODAY(-8), "Yellow", "Green")))
Here it is in context
2.
This formula will put nothing into your symbol column if Phase is blank
=IF(ISBLANK(Phase@row), "", IF([Exec Summary Update]@row < TODAY(-14), "Red", IF([Exec Summary Update]@row < TODAY(-8), "Yellow", "Green")))
3.
To combine both of these logics use
=IF(OR(ISBLANK(Phase@row), Phase@row = "Closed"), "", IF([Exec Summary Update]@row < TODAY(-14), "Red", IF([Exec Summary Update]@row < TODAY(-8), "Yellow", "Green")))
-
@KPH - thank you for your thorough and accessible walk through! I loved it!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!