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

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:
· Share on FacebookShare on Twitter

Comments

  • SmSulli
    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

     

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories