Restricting Number Format in Forms

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.

Find more posts tagged with

Forms

Comments

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

Paul 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.

tmayhall

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

tmayhall

Very creative! Thanks!

Andrée Starå

Great!

Happy to help!

Best,

Andrée

Paul Newcome

Happy to help.

Anita Milasinovic

Hi,

is there a way to add currency in forms validation (like the phone number validation automatically offers different country prefix but then for country's currency)?

Thanks!

Anita

Caroline Sheldon

@tmayhall @Paul Newcome @anita M

You can validate form fields for certain inputs.

Text/number column validated to number, percent, email, phone

Contact column validated for email.

See more information here: https://help.smartsheet.com/articles/2482427

Screen Shot 2021-08-02 at 3.23.03 PM.png

Paul Newcome

@Caroline Sheldon Yes. Very happy that the feature has been added but couldn't remember every post about field validation to be able to update. Haha

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…