Restricting Number Format in Forms

edited 12/09/19 in Using Smartsheet
11/30/18 Edited 12/09/19

Is it possible to restrict the number format of form entries for text/number fields? 

I have some fields which are formatted for currency in the sheet, but the form will permit text to be entered in these fields.  I see restriction for Date/Time, Dropdown, Contact List, and Checkbox, but not for the broader Text/Number fields.

Popular Tags:

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi,

    Unfortunately, it's not possible natively in Smartsheet att the moment, but there are third-party solutions that can do it. A possible workaround could be too clearly have some text describing what's expected and approved in the fields.

    Would that work?

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    You could also use a checkbox column with a formula that will say something along the lines of

     

    =IF(NOT(ISNUMBER([Column Name]@row)), 1)

     

    This will check the box if the entered data for the specified column in that row is not a number. You can then set up an update request to automatically send to the submitter if that box is checked requesting that they adjust the value to be only a number.

  • Thanks, Andree.  I'll use that as a workaround.

  • Very creative!  Thanks!

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Great!

    Happy to help!

    Best,

    Andrée

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help. yes

Sign In or Register to comment.