Label Status Dot Help
Hey all!
I am trying to add the color symbol dots to align with status and I've tried so many formulas, I cannot for the life of me figure this out. Nothing crazy in this sheet, just want to align the status to the color of the dot.
If Status = Complete —> Green
If Status = In Discovery, In Process, In Review —> Yellow
If Status = Won't Do, Blocked —> Red
If Status = To Do, In Discovery, Backlog —>
Please help!!
Best Answer
-
Amazing, thank you!
Answers
-
=IF(OR(Status@row = "To Do", Status@row = "Backlog"), "Gray", IF(OR(Status@row = "Won't Do", Status@row = "Blocked"), "Red", IF(OR(Status@row = "In Discovery", Status@row = "In Process", Status@row = "In Review"), "Yellow", IF(Status@row = "Complete", "Green"))))
Larry Cummings
https://primeconsulting.com/
Principal Consultant | Prime Consulting Group -
Amazing, thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.3K Get Help
- 392 Global Discussions
- 213 Industry Talk
- 447 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!