nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Why are users able to enter over 100% in %Complete column?

djpreece

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-

Find more posts tagged with

Comments

J. Craig Williams

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

djpreece

Thanks Craig

Odd indeed, especially since the column is part of project tracking dependencies!

J. Craig Williams

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.

Craig

Brad Jones

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.

J. Craig Williams

As long as the limit is not universally imposed, I'm all for constraints/validations on a column level (like restricted drop down lists)

Craig

Sign in to join the conversation!

Quick Links

Trending discussions

"Fields marked with an asterisk (*) are required." line on every form.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
Dynamic View Issue - Group Sharing
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…