Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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)
Is anyone else experiencing this issue today (7/28/2026)? Every time an automated email triggers on its own today, whether it's a regular alert, update request, etc, the values that usually appear when the automation workflow includes a field in curly brackets (ex: {{First Name}}) appears as a weird alphanumeric value in…
Hi - Is anyone else having problems with placeholder fields in update request automations today? I've been notified by my staff that our automations today are showing random text strings instead of the field data that they are supposed to. For example, in one of my sheets, there's an automations thatis supposed to show a…
Hello to all the community, my team is experiencing an issue with the notifications in Smartsheet. In the last hour the notifications started including only the placeholders of the columns, instead of the content of the related cell. I checked with the support and this could be related to changes in the workflow or in the…
