Why are users able to enter over 100% in %Complete column?

djpreece

Hello

Surprised to see users can enter over 100% in %Complete column.

I tried to constrain with pull downs but that isn't allowed for project dependencies...

Any thoughts?

-dp-

J. Craig Williams

While the column name is "% Complete", the formatting is based on percent and there is no constraints in the column for range.

It struck me as odd when I first starting using Smartsheet, but I got used to it.

Maybe they will add data validation on Text/Number and this could be user defined, but I am not betting on it.

Craig

djpreece

Thanks Craig

Odd indeed, especially since the column is part of project tracking dependencies! 

J. Craig Williams

Originally, the Duration column was not marked as special column -- it was just a Text/Number column with the Duration features. Maybe they will do the same with % Complete.

Craig

Brad Jones

Could definitely use this.  Currently I have a special auto-formatting rule set up to highlight when a % Complete cell is greater than 100%, but as all formatting rules create a processing burden on your sheets - it would be much nicer if this could simply be handled with a limit.

 

J. Craig Williams

As long as the limit is not universally imposed, I'm all for constraints/validations on a column level (like restricted drop down lists)

Craig