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.
Common formatting of Percent Complete.
Hi everyone - I like to format my rows so that things that are complete are green and things that are late are red.
So I created some conditional formatting so that if a task was 100% complete then it was green and if it had a due date in the past and was not 100% complete it was red.
I was pretty happy until I added some parent rows.
Parent rows measure completeness from 0-1 not 0-100.
So I added to both 100 and 1 as the values that would turn a row green.
Does it seem odd to other people that children are measured on a 0-100 scale and parents on a 0-1 scale?