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.
Setting Conditional Formatting/Formulae(?) for Red Yellow Green balls based on % Completed
I am trying to have the Red, Yellow, and Green status balls automatically change/update based on the percent completion of each row task. When I click on the conditional formatting button in navigation pane and make new rule of, "If % Complete is between range of 1% and 99%, then change the status column to Yellow" the change actually makes the entire cell yellow, but leaves the balls unchanged... Additionally I think I would create a rule of, "if % Complete is equal to 100%, then change the status column ball to Green", but ideally this would change that little colored ball, NOT the entire Status Cell.
Hopefully there's a way to do this as using "% complete" AND the "Red, Yellow, Green" balls in status columns become therefore redundant and not very satisfying upon task completion due to the status columns for R,Y,G being only manually updatable.
Thank you for any input!