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



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


    Aravind GP| Principal Consultant

    Atturra Data & Integration

    M: +61493337445


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!