Label Status Dot Help

tylermartins

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!!

Larry

=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"))))