Form Submission Issue - Dropdown list with Integer values

Options

Hi

In one of my sheets I have a dropdown column that has only integer values from 1-20 and it is restricted to these values only. Also, I have an online form where users before submitting data, they would select from the list any value from 1-20. This was working fine till last week. Now whenever the user submit the data using the form it appends .0 to the selected value. For example, if the user selected 5 from the dropdown list and click submit it appears in the sheet as '5.0 and this is causing issues on the formulas in my sheet and affecting the reports.


Best Answers

Answers