Sign in to join the conversation:
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!
Hi there, I've created a sheet to where my team is tracking information received. In one column, we are logging the date and time information came in (ie: November 21, 2025 8:30 AM). I would like to add a checkbox column, with a formula specifying that the box be checked if the logged time is AFTER 8:30 AM, and left…
I have a list of properties that I'm keeping track of. I have each building divided into suites (children) and each suite has a cell with its square footage. The total square footage rolls up to the building name. I also have a drop down column that shows if the suite is occupied or vacant. I need a to calculate the…
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
