Checkbox checked, cancel RYG

oakhayat

Hello,

I have created 3 columns for the RYG, if the project is in the early stages the color green will show, if it is due within 4 days, yellow will show, and when it is due in 2 days red will show.

Now I have a checkbox for the employees to click if the work is complete and I want the RYG colors disappear when they click it, how can I do that?

 

Thanks

Robert S.

Hello,

 

Thanks for the question. We have a blog post on how to automate RYG balls, which includes wether or not a checkbox is checked. You can read more on this here (https://www.smartsheet.com/blog/support-tip-automate-RYG-balls).

 

Using the information you've given and the information in the blog post, Here's an example of how this formula could be written:

 

=IF([Complete Checkbox]1 <> 1, IF(TODAY() - [Due Date]1 >= -2, "Red", IF(TODAY() - [Due Date]1 >= -4, "Yellow", "Green")))

 

You may need to update the column names and row number in the formula to work in your sheet.