Is there a function that will change the Health RYG Balls color?
Is there a function that will change the Health RYG Balls color if a specific criteria is met. Such as Budget, due date or other?
Best Answer
-
Hi @Lori Cross
You can use just about any function you would like, as long as it will results if true are written as "RED", "YELLOW", or "GREEN", and the function is written in your RYG formatted column.
Example:
=if(Today()>=[Due Date]@row, "Yellow", "Green")
This is very simple example, but you can write just about any formula (simple or complexicated) to complete what you are seeking.
Answers
-
Hi @Lori Cross
You can use just about any function you would like, as long as it will results if true are written as "RED", "YELLOW", or "GREEN", and the function is written in your RYG formatted column.
Example:
=if(Today()>=[Due Date]@row, "Yellow", "Green")
This is very simple example, but you can write just about any formula (simple or complexicated) to complete what you are seeking.
-
I have to take a look but because I have the column formatted as symbols not sure how it will work. Thanks!
-
Yes, you can use an IF statement in the RYG column to automate the ball colors.
=IF(Status@row = "Complete", "Green", IF(Status@row = "In Progress", "Yellow", "Red"))
Would change the color of the ball based on Status of Complete. Here is a great article about automating RYG Symbol columns.
Basically, you use the name of the symbol (found in the dropdown) to activate that symbol. In my example above, the color of the balls is the name of the symbol that appears next to it when you are using the dropdown.
For more on IF statements see:
For more on Column Symbols see:
-
Thanks - I will keep you posted!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!