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)
The timeline widget seems to only allow filters to be set when you are editing the widget (see green highlight screenshot). Which is fine, but it would be more valuable to have regular users be able to adjust filters directly from the dashboard, similar to how there is an option to adjust the timescale. Am I missing…
Can someone help me and give me an idea on how to create a cost estimate for installations, with a total for each chapter by groups, subgroups and types of work, but at the bottom of each chapter. https://us.v-cdn.net/6031209/uploads/0OSH46KSC2LH/cost-estimate.xlsx Thanks
I created a new sheet for my team by replicating an older sheet and now my tasks aren't pulling into my task report or any of my teammates. I confirmed the sheet was selected in my report but it still isn't pulling in. I've never had an issue with this before so would love some advice on troubleshooting.
