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

Options

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

  • AravindGP
    AravindGP ✭✭✭✭✭✭
    Options

    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| Principal Consultant

    Atturra Data & Integration

    M: +61493337445

    E:Aravind.GP@atturra.com

    W: www.atturra.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!