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.

Automate RYG Balls based on % complete and start and end dates

edited 12/09/19 in Archived 2017 Posts

I would like to have the RYG balls automatically adjust based on the percent complete and start and end date. 

For instance, if my task is set to start on 10/2/17 and end 10/13/17, if my % complete is less than 50% by midway between the two dates, to turn yellow. If my % complete is less than or equal to 90% by the end date to turn red. 


This discussion has been closed.