Limit entry of % complete column

LeanneScheepers

Is it possible to limit the entry of a % complete column to make my sheet more 'foolproof'? So only allow entries between 0 & 100 %?

 

E.g. I use a conditional formatting rule that when a % complete is 100% that a row is 'grayed out', but if someone accidentally add 110% then  no conditional formatting is applied.

Shaine Greenwood

Hi Leanne,

 

We currently don't have data validation such that values can be restricted or limited in a column but I've got your vote down for this on our enhancement.

Mike Andreas

Would formatting a column as a dropdown not work for percent?

 

I answered another discussion in detail that has equations that may suit your need.  If someone enters something above 100%, the RYGB status ball column shows red when it would be desired to show as blue.  This may be enough of a trigger to the user that something is wrong.  If the Actual Percent Complete column in my screenshot below could be formatted as a dropdown, this would be even better for you.

 

Might want to search on my posts and check it out.

 

LeanneScheepers

Hi Mike,

 

Nice workaround. The RYG-balls aren't necessary for my purpose, but I can always make a dropdown list with the options that I want to allow, e.g. 0%-25%-50%-75%-100%.

 

--edit--

While trying to edit the column properties to a dropdown list, I got the following message. Any thought whether the solution that Mike suggested is applicable?

 

Thanks!