Form value of 1 in percentage column captured as 1% not 100%
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.
Answers
-
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%
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives