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

Otman

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

AravindGP

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, ".", ",")