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

Megan Burns
Megan Burns ✭✭
edited 12/09/19 in Archived 2016 Posts

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

  • Christian Wells
    Christian Wells ✭✭✭
    edited 12/22/16

    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.

This discussion has been closed.