Numbers only validation not working.

Options
BD
BD ✭✭
edited 03/18/24 in Smartsheet Basics

Hello Everyone. Is anyone else having an issue when using a text/number field with number only validation turned on? It started on 3/12/24. If I type 0045 in the form or sheet, it will make it a text.

Thank you

Answers

  • Itai
    Itai ✭✭✭✭✭✭
    Options

    Hi @BD

    I also noticed that an "e" counts as a number for some reason and can be added when its numbers only.

    From my experience when you add zeros before a number it always transforms it into text.

    Itai Perez

    Project Manager | Transformation Department

    Gong cha

    If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

    https://www.linkedin.com/in/itai-perez-740543116/

  • BD
    BD ✭✭
    edited 03/18/24
    Options

    Prior to 3/12/24, it worked great. It would drop the zeros and add just the numbers. We were using this sheet to input weights from a scale. This was used in multiple locations and was working great for almost a year. I did check to make sure my scales are sending the correct data. Everything checks out ok.