Form Submission Issue - Dropdown list with Integer values

Ali AlRumaih

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.

Column Values.png

Form Values.png

Form values before submit.png

Sheet Values.png

Cell Value.png

Ali AlRumaih

I opened a ticket for this issue with the support team but didn't get any feedback yet

fraygosa

@Ali AlRumaih did they fix it? Its still happening to my sheet

Ali AlRumaih

I opened a ticket for this issue with the support team but didn't get any feedback yet

Andrée Starå

Hi @Ali AlRumaih

I hope you're well and safe!

There seems to be an issue at the moment, or a change has been made.

If you haven't already, I recommend reaching out to the Smartsheet Support Team.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Ali AlRumaih

Thanks Andree, and yes I opened a ticket with Support team but didn't get any feedback till now.

Andrée Starå

@Ali AlRumaih

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

fraygosa

@Ali AlRumaih did they fix it? Its still happening to my sheet

Ali AlRumaih

https://community.smartsheet.com/discussion/comment/331215#Comment_331215

Yes it was fixed but no body contacted me about the fix they applied. Just woke up and found the issue resolved