Restricting Number Format in Forms

tmayhall · 11/30/18

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å · 11/30/18

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 · 12/03/18

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 · 01/28/19

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

tmayhall · 01/28/19

Very creative! Thanks!

Andrée Starå · 01/28/19

Great!

Happy to help!

Best,

Andrée

Paul Newcome · 01/28/19

Happy to help.

Anita Milasinovic · 09/03/21

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