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.
Limit entry of % complete column
Is it possible to limit the entry of a % complete column to make my sheet more 'foolproof'? So only allow entries between 0 & 100 %?
E.g. I use a conditional formatting rule that when a % complete is 100% that a row is 'grayed out', but if someone accidentally add 110% then no conditional formatting is applied.