dot and comma to separate dollar and cents
Some colleagues in US or other countries all over the world capture data via a form into Smartsheet. Sometimes cents are neeeded so the dot will be used to separate the dollar from the cent.
My account is in Germany and the the Germans use the comma for separation not the dot.
All data run into a failure and I have to delete the dot and to enter a comma.
Within the form its only possible to proof for an amount not how much digits have to be captured on the right side of the comma.
How can I improve this.
Thanks for your comments
UWE
Answers
-
Hello @u.brinkrode98571,
There may be a better way to do this, but one solution would be to create a secondary column and enter this as a column formula:
=SUBSTITUTE([Name of Column]@row, ".", ",")
You could then utilize this column when exporting data to any application that requires commas.
-
The proposal works but isnt this a workload of the system?
Thanks a lot for your help
UWE
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives