Sign in to join the conversation:
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-
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
Thanks Craig
Odd indeed, especially since the column is part of project tracking dependencies!
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.
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.
As long as the limit is not universally imposed, I'm all for constraints/validations on a column level (like restricted drop down lists)
Hi My Smartsheet Business account was inactive for 3-4 months; but now when it's active again, I do not have the permission to delete my old data (I tried deleting a single item like a sheet but it didn't work). Some facts: All the old data was created by me only. There is no other person in my Smartsheet account. I never…
Hi, I am running timelines on a master sheet for high level tracking of a few different things. Rather than adjusting the timeline settings to get each view needed, I’ve created a set of reports set to timeline that are permanently grouped and filtered as needed. I want to use the “Show empty lanes” option under Group in…
We are UK based and use the Day/Month Date Format (i.e 09/02/2026 - 9th of Feb 2026) In some, but not all, of the "Send.." rows email, the date format changes to the American version (02/09/2026). Is there any way to stop this happening?
