Help with IF(AND) function
I have been trying to figure out where the issue(s) with my formula is awhile. I have tried to break the formula down in sections too, that didn't help. Is anyone able to help with my formula?
What trying to do use RYG symbols:
Refer to the Stage of Project Column, IF = Kick-off AND Wait List & PM Assignment = "" (blank), then leave blank. IF Stage of the Project = Kick-off AND Wait List & PM Assignment < TODAY (15) then Red, IF Stage of Project = Kick-off AND Wait List & PM Assignment < TODAY (-7) then Yellow, IF Stage of Project = Kick-off AND Wait List & PM Assignment is TODAY, then leave blank, Green.
Formula:
=IF(AND([Stage of the Project]@row = "Kick-off", [Wait List & PM Assignment]@row = “”)), “”, IF(AND([Stage of the Project]@row = "Kick-off", [Wait List & PM Assignment]@row < TODAY(-15))), "Red", IF(AND([Stage of the Project]@row = "Kick-off", [Wait List & PM Assignment]@row < TODAY(-7))), “Yellow”, IF(AND([Stage of the Project]@row = "Kick-off", IF([Wait List & PM Assignment]@row > TODAY()))), “”, “Green”))))
I am still fairly new to Smartsheet, sorry if my formula is completely off. Any help would be greatly appreciated.
Best Answer
-
Try this instead:
=IF([Stage of the Project]@row = "Kick-off", IF([Wait List & PM Assignment]@row< TODAY(-15), "Red", IF([Wait List & PM Assignment]@row< TODAY(-7), "Yellow", IF([Wait List & PM Assignment]@row> TODAY(), "Green"))))
Answers
-
Try this instead:
=IF([Stage of the Project]@row = "Kick-off", IF([Wait List & PM Assignment]@row< TODAY(-15), "Red", IF([Wait List & PM Assignment]@row< TODAY(-7), "Yellow", IF([Wait List & PM Assignment]@row> TODAY(), "Green"))))
-
Thank you so much! It worked and is much simpler! I have been fighting with the formula for two days!
-
I spoke too soon. I no longer am getting the #UNPARSEABLE error, but it isn't providing the results. If the Stage of the Project is Kick-off, it isn't resulting in the RYG dot in the column with the formula.
-
I should have gave more context. The Stage of the Project is Kick-off, the date in Wait List & PM Assignment is more than 15 days in the past, it should return a Red dot, the cell was blank.
-
Can you provide a screenshot of the formula open in the sheet as if you are about to edit it?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!