Formula issue
Hi
Can someone help me to write these five formula in a single formula to get the schedule health.
IF(Status@row = "Not Started", "Gray")
IF(Status@row = "On Hold", "Yellow")
IF(Status@row = "Not Applicable", "")
IF(Act1@row >Act2@row , "Red")
IF(Act1@row <Act2@row , "Green")
THanks
Answers
-
Hi, @Finops C'ship.
Give this a try...
=IF( Status@row <> "Not Applicable", IF( Status@row = "Not Started", "Gray", IF(Status@row = "On Hold", "Yellow", "")), IF(Act1@row > Act2@row , "Red", "Green"))
-
Its not working...we have 4 colors symbols
if the status is set as Not applicable it should be "" i mean without any color..can you help
-
Hi, @Finops C'ship ,
Thanks for the feedback. I see the error in the formula...
Try this...
=IF( Status@row <> "Not Applicable", IF( Status@row = "Not Started", "Gray", IF(Status@row = "On Hold", "Yellow", IF(Act1@row > Act2@row , "Red", "Green"))), "")
Here is the formula formatted so that it's a little easier to read
=IF( Status@row <> "Not Applicable" , IF( Status@row = "Not Started" , "Gray" , IF(Status@row = "On Hold" , "Yellow" , IF(Act1@row > Act2@row , "Red" , "Green" ) ) ) , "" )
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!