IF formula return RYG symbol based on Status
Hello - I am very new to Smartsheet and am trying to write what I think is a simple formula, but I keep getting an Incorrect Argument error. This is what I need:
If Status = In progress, green ball
If Status = On Hold, red ball
If Status = Complete, grey ball
If Status = Not Started, yellow ball
Best Answer
-
That should be something like:
=IF([Status]@row = "In Progress", "Green", IF([Status]@row = "On Hold", "Red", IF([Status]@row = "Complete", "Grey", "Yellow")))
Hope it helped!
Answers
-
That should be something like:
=IF([Status]@row = "In Progress", "Green", IF([Status]@row = "On Hold", "Red", IF([Status]@row = "Complete", "Grey", "Yellow")))
Hope it helped!
-
Hi @David Joyeuse That was exactly what I needed - I just had to change "grey" to "gray" and it worked perfectly. Thank you!!!
-
Follow up comment - What I was doing wrong was trying to write an IF to return the Yellow, instead of leaving the Yellow as the item to return if the first three weren't selected. Light bulb moment!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!