Form value of 1 in percentage column captured as 1% not 100%

bradmcnair

I have a form that captures data in a column with percentage formatting applied. If a decimal value is selected such as .5 the data is properly captured in the sheet at 50%, but if 1 is selected it is captured ad 1%, not 100%. I've tried to change the value to 1.0 and 1 and the behavior is the same. In the sheet itself if I choose 1 from the value dropdown it is properly adjusted to 100%, only data entered via the form is incorrect.

Jeff Reisman

On your form, activate the new field validation setting for your percentage column. This will essentially prompt the person to enter the full percent. Then it records whatever the person entered correctly.

1 = 1%

50 = 50%

100 = 100%

.5 = 0.5%

bradmcnair

The column is set up as a dropdown list now so the validation option isn't available, but if it's a known issue with that type I'll change it to text.