Restricting Number Format in Forms

tmayhall

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.

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

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