RYG Balls

klauman69086

For this formula, I would like the RYG balls to be the result.  Instead, I’m getting the word “Green” or “Red”.  So the formula is working, but would like the balls and not the word.

klauman69086

here is the formula:

=IF([Acknowledge Phaco Care & Maintenance SOP]24 = "Acknowledge/Disagree, i have further input", "Red", IF([Acknowledge Phaco Care & Maintenance SOP]24 = "Acknowledge/Agree", "Green"))

Andrée Starå

Hi,

Change the column type to symbols (RYG) and it should work.

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

klauman69086

Hi - i have it set to symbols, the check mark inside the green circle and the 'x' within the red circle.

 

Andrée Starå

Ok.

Then it should be Yes, Hold, No instead.

Kind regards,

Andrée

klauman69086

Got it!

I can't designate responses to return the RYG... changing to the Yes, No, Hold worked.

Thanks!

Andrée Starå

Excellent!

Happy to help!

Best,

Andrée