Using full stops or commas for numbers

***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
Best Answer
-
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; "."; ","))
Answers
-
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; "."; ","))
-
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...
-
Dear Ones I found a BUG n the Italian version of Smartsheet regarding this topic
That's the explanation for Italian folks only
The Form "convalida" is not Working in Italian for Numbers
Please @SmartSheet Admin could you try to solve the problem?
-
Just use Value(Spesa@row) in an auxiliar column. No substitutions! And it will work. The same problem in Brazil, but I can manage using only VALUE.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives