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)
Greetings- I have a drop-down column where a staff member is emailed (request an update) if a row is marked as "assigned". If row 1,2,3 are assigned to the same staff member within a few mins, that staff member receives 1 email rather than 3 separate emails. We want each row to be a separate email so they can mark that row…
All of the automation workflows on all our sheets are "missing". This is what we see when we click "manage automation workflows" We're also unable to create new workflow. Smartsheet Gov Status shows no issues with workflows. Is anyone else experiencing this issue?
Hi. I have been the System Admin for the past 2 years. When I came into this role, I added our logo under the setting in Branding & Personalization. Our logo has now changed and I need to update it. However, when I go to Branding & Personalization the only options I have are Profile Visibility and Working Days. Did…
