Is there a function that will change the Health RYG Balls color?

Lori Cross

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?

John Jonassen

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.

John Jonassen

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.

Lori Cross

I have to take a look but because I have the column formatted as symbols not sure how it will work. Thanks!

Mike Wilday

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:

https://help.smartsheet.com/function/if

For more on Column Symbols see:

https://help.smartsheet.com/articles/2480316-available-symbols-in-symbols-column

Lori Cross

Thanks - I will keep you posted!