RYGB symbols automated to reflect status/progress

JWattz

Hi there, Attempting to write formula to automate RYGB symbols when task is In Progress, On Hold or Complete. I've prepared a few formulas and none seem to be accurate. If someone would take a look at below attempts and let me know what needs to be changed, I'd greatly appreciate it!

None of below worked:

=IF(OR([Status]6 = In Progress, ”Blue”,

IF ([Status]6 = On Hold, ”Yellow”,

If ([Status]6 = Complete, ”Green”)))

 

=IF([Status]6 = In Progress, ”Blue”,

IF ([Status]6 = On Hold, ”Yellow”,

If ([Status]6 = Complete, ”Green”)))

 

=IF(Status6 = In Progress, ”Blue”,

IF ([Status]6 = On Hold, ”Yellow”,

If ([Status]6 = Complete, ”Green”)))

Then, attempting using numbers rather than text:

=IF ([Status Numeric]6 = 2, ”Blue”,

IF ([Status Numeric]6 = 3, ”Yellow”,

If ([Status Numeric]6 = 4, ”Green”)))

Thanks!

SYSPK

All of your texts like "complete," "on hold," etc.. need to be in quotation marks. 

Also, I see an OR formula up there but it doesn't seem necessary, because you want different things to happen for the different statuses. If you wanted the same thing to happen, like if you want the ball to turn blue if the status was "in progress" or if the status was "on hold," then you would use OR. But it looks to me like you want different things for each. You'd use a nested IF like this, and put all of your conditions in quotation marks.

IF([status]6 = "in progress", "blue", IF([status]6 = "on hold", "yellow", IF (etc...

You don't need to worry about counting the right amount of ending parentheses at the end, )))))), because if you leave those blank the sheet will fill it in for you. So long as you set it up correctly in the beginning of all the IFs.