Numbers only validation not working.

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

· Share on FacebookShare on Twitter

Answers

  • Itai Perez
    Itai Perez ✭✭✭✭✭✭

    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

    Reporting and Project Manager

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

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

    · Share on FacebookShare on Twitter
  • BD
    BD ✭✭
    edited 03/18/24

    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.

    · Share on FacebookShare on Twitter

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video