Labels for RYG Balls

Tim@hubb

Hello

 

I am sure it is an easy answer, but, I cant seem to find information.

Is there a way of having a label associated with one of the RYG balls, ie when the green ball is selected, the next column says 'Active', The red ball would be 'On Hold' etc.

 

SmSulli

Use this formula in the column next to your Status column.  You'll need to change the column name in the formula.  and customize it so it says what you need.

=IF(Status1 = "Red", "Late", IF(Status1 = "Yellow", "On Hold", IF(Status1 = "Green", "Active", "")))

Good Luck

Shawn