Leave blank if none of these...Function
How do I take this function and include so that if all are false the cell stays empty?
=IF(CEO Approval to Re-Open]@row = "Approved", "Green", IF[CEO Approval to Close]@row = "Declined", "Yellow", "Red"))
Best Answer
-
So if I understand correctly. You have an approval automation on the CEO Approval to re-open column which is either Approved or Declined and you want to have the RYG balls be red if no action has been taken by the approver?
You could add an option to the dropdown such as Submitted or No Action and make that the default option as soon as your automation runs. The RYG ball would then remain red untill the request has been approved or declined.
Would something like this work or must the cell be empty?
Michelle Basson
Smartsheet Overachiever Alumni | Solution Architect | Lover of everything Smartsheet
https://www.linkedin.com/in/michelle-basson/
CERTIFIED SMARTSHEET PLATINUM PARTNER
www.projectplanservices.co.uk
Answers
-
Hi @HardWork
Try this
=IF([CEO Approval to Re-Open]@row = "Approved", "Green"; IF([CEO Approval to Re-Open]@row = "Declined", "Yellow", IF([CEO Approval to Re-Open]@row, " ", "Red")))
The " " will detect if there is nothing in the cell and the make the RYG Ball Red.
Please let me know if this works for you.
Have a great day.
Michelle
Michelle Basson
Smartsheet Overachiever Alumni | Solution Architect | Lover of everything Smartsheet
https://www.linkedin.com/in/michelle-basson/
CERTIFIED SMARTSHEET PLATINUM PARTNER
www.projectplanservices.co.uk -
Thank you so much!
Unfortunately it did not work. So this is a two stage approval process. Stage one is to approval/deny closure. Then later, stage two is approval/deny to re-open. So two columns the function is looking at.
-
So if I understand correctly. You have an approval automation on the CEO Approval to re-open column which is either Approved or Declined and you want to have the RYG balls be red if no action has been taken by the approver?
You could add an option to the dropdown such as Submitted or No Action and make that the default option as soon as your automation runs. The RYG ball would then remain red untill the request has been approved or declined.
Would something like this work or must the cell be empty?
Michelle Basson
Smartsheet Overachiever Alumni | Solution Architect | Lover of everything Smartsheet
https://www.linkedin.com/in/michelle-basson/
CERTIFIED SMARTSHEET PLATINUM PARTNER
www.projectplanservices.co.uk -
Great idea!!! I added in another option and made the function turn a different color if all options are blank!!! Thank you!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!