Clear RYGB balls on completion of a task

TAdams
TAdams
edited 12/09/19 in Smartsheet Basics

Hello,

 

Currently we are using the RYGB balls as a priority indicator. One of the things that happens when you are completed with the task is that you have to clear the ball manually. I would like to automate the task. 

<Column 1> RYGB

<Column 2> is a drop down with the following  "Canceled", "Pending" and "Released".

 

I would like to automate this so that when you select "Released on Column 2, Column 1 is cleared of any RYGB balls. Does anyone have any ides?

 

Regards,

Tom

 

 

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You would have to automate all of the colors. Once you manually enter or change something in a cell, it will overwrite the formula.

  • I made a mock up formula that may help, I automated the RYGB based on a prior symbol column with "yes", "no" or "hold" options, and then used a nested IF formula.

    =IF([Dropdown Column]1 = "released", "", IF([Symbol Column]1 = "Yes", "Green", IF([Symbol Column]1 = "Hold", "Yellow", IF([Symbol Column]1 = "No", "Red", "Blue"))))

    This formula goes into the RYGB column, and will appear blank if the dropdown column is "Released"