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)
Has anyone found a workaround for sharing Smartsheet reports externally without giving access to internal data? I currently have to download the data and transfer it onto excel to create a pivot table for our client and I want to find an easier way to do so. I also already create a dashboard for our client, but I wanted…
Hello team! Hope you all are having a wonderful holiday season. I am trying to set up an automation that will send an email reminder one time when Next Update Date = 60 days, then another automation at 30d, etc. The key is I only want it to send the reminder one time when Next Update threshold is reached. Is this possible?…
I have an automation setup to escalate to managers when a step goes beyond 2 days. I have that titled as Escalation for Purchasing, Escalation for Planning, etc. In my trial run, 3 out of 6 showed up as Reminder: New part number request log ( this is the name of the sheet) The only thing we could see was that the ones that…
