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.
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"))
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
Hi - i have it set to symbols, the check mark inside the green circle and the 'x' within the red circle.
Ok.
Then it should be Yes, Hold, No instead.
Kind regards,
Andrée
Got it!
I can't designate responses to return the RYG... changing to the Yes, No, Hold worked.
Thanks!
Excellent!
Happy to help!
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…
