Using full stops or commas for numbers

radix

***Translated via Google Translate by a Moderator as the Community is currently only supported in English***

Good morning, I have a problem regarding the random use of commas or periods when entering numbers in a smartsheet form.

In the Italian version, in fact, if you use a point instead of a comma, the cell is no longer identified as a number but as a text and in the summary counts it obviously gives an error

I know that it depends on the language in the sense that if I use the Italian language the decimals must be entered with the COMMA ( , ) and not with the period, but it happens more and more often that customers continue to use the period and this causes all the summaries in real time.

I wanted to understand if when composing a form, in the formatting of the "number" format just as it is possible to prevent the use of letters if I select "number only", there was the possibility of forcing the user (at least in the Italian format) to use the comma and not the point for decimals.

Grazie

Paul Newcome

You can't force the user to use commas vs periods in the form directly, but what you can do is insert a helper column on the sheet and use a formula to swap any periods out for commas and convert it into a numerical value.

=VALUE(SUBSTITUTE(Spesa@row; "."; ","))

Paul Newcome

You can't force the user to use commas vs periods in the form directly, but what you can do is insert a helper column on the sheet and use a formula to swap any periods out for commas and convert it into a numerical value.

=VALUE(SUBSTITUTE(Spesa@row; "."; ","))

radix

Thanks! Great Roundabout!!! 👍️

Work with the text but there is a problem with the Value function that transoform the number as if the dot do not exist... I do not know why...

radix

Dear Ones I found a BUG n the Italian version of Smartsheet regarding this topic

That's the explanation for Italian folks only

https://youtu.be/Wwmbc8moReA

The Form "convalida" is not Working in Italian for Numbers

Please @SmartSheet Admin could you try to solve the problem?