How to use "," instead of "." in a smartsheet culumn

Hi,
I have a form that follows a temperature range in a room, and when the temperature values are entered with a "." like 23.5 degré my formula to indicate if the temperature is < 10 or > 23 does not wortk. But when the temperature value id entered "," like 23,5 degré its works.
How can i make that the temperature value can only be entered "," or how to change in a smartsheet culumn the "." by ",".
Thank you for your help
Answers
-
Hi @Otman
You can create another column which converts the dot to a comma through a formula and then use this new column to drive your other formula. You can use =SUBSTITUTE([column that has the value entered]@row, ".", ",")
Thanks,
Aravind GP| Delivery Manager
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!