I have dropdown values as numbers like below
However when the form is submitted, they look like text
When i manually change them from gridview, they are in number format
I set the column to no decimal places, and changed my form to radio buttons like yours. I got the same results as I did before:
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
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!
In the sheet, select the column with your numbers. Use the decimal buttons to set the column to show numbers with one decimal place (1.0, 2.0, etc.) This should tell Smartsheet that you want these to be saved as numbers.
I created the column above and set the decimal to one decimal place. It's a single-select dropdown column with choices of 1, 2, 3, 4.0, 5.0, 6.0.
When I selected "2" from the dropdown and submitted the form, it saved as 2.0 on the right side of the cell, indicating it's a number value.
When I selected "6.0" from the dropdown and submitted the form, it saved as 6.0 on the right side of the cell, indicating it's a number value.
When I placed math formulas referencing these cells in a neighboring column, they calculated correctly, further proving they are saving as numeric values:
Thanks a lot for your interest on the subject. I have tried your solution an it didn't work.
The problem was my regional settings. In Turkey, we use comma for decimal points and smartsheet does not consider regional settings on forms. Therefore numbers with point decimals register as texts.
I have a certification that requires a few lessons to be fully certified. Each lesson has a completion date in it's own column and a date column for when they become fully certified. So, if there if one training is missing a completion date they are not considered fully certified. My need is to be able to collect the max…
Hi, I'm sure its a big use of smart sheet, I use various registers to store documents especially drawings. Each row is a drawing or document, if there are different Issues I use the upload new version. There are the Ref#, Issue#, description and drawn date columns etc. The drawing is a pdf attachment. However you can not…
I have a sheet with a start date and an end date. I would like a checkbox column to be checked if that date range includes a Friday. Any ideas on how I would do that? Thank you in advance. Jennifer
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.