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.
Percent Complete by Cell Color

Is there a formula to determine percent complete of a task based on the cell color? Cells are filled with dates of various steps in a project and once those are completed, the cell is highlighted. I'd like to have the percent complete column update automatically when the cell color is changed.
Β
Help, please!
Comments
-
Hello Megan,
I dont believe there are colour base formula's or fomatting.
Β
I would suggest the reverse of what you are doing...
Β
Base your cell colouring on the % compelte value, using Conditional Formatting.
Β
Have you staff update their percentage complete (even by dropdown) and then colour specific cells or the whole line based on this value.Β You could even use theΒ Symbols Β to manage the Percent Complete column.