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!
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…
