Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Labels for RYG Balls

Options
Tim@hubb
Tim@hubb
edited 12/09/19 in Archived 2017 Posts

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.

 

Tags:

Comments

  • SmSulli
    Options

    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

     

This discussion has been closed.