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

Workspace is still there but all folders are empty
Hey, I had a Project in January where I created multiple sheets, dashboards etc. Now I want to prepare the same project again but all folders are empty. Not a single sheet is left. How is that possible ? I upgraded to a paid account during that time and Iwanted to do that again but smartsheet do not delete everything if…
Sheet getting full
Looking for any thoughts on how to handle the situation of a sheet nearing its 500,000 cell capacity. We have a sheet that collects data from multiple team members who submit it via a form. The sheet is for the most part a repository of this submitted data and other sheets, reports and dashboards query the main sheet for…
Solution to manage accidental deletion
Good afternoon, Recently we have started one of our sheets in Card View and on a handful of occasions, we have had users deleting cards (or rows) from the sheet, simply by clicking the delete button on the keyboard by accident. I have done a manual test on a copy of the sheet and doing so does not prompt the user to ensure…