Validating data input in a Form

I have set up smartsheets to collect data with forms for the users at our facilities. The operators check equipment and enter the data in the form. Sometimes, they fat finger it - or forget the decimal point which causes an out of spec condition and email notifications. Is there any way to validate the data and the user get an error message (maybe based on really out of whack conditions I would set up)???

Smartsheet form example.JPG

Find more posts tagged with

Forms

Manufacturing

Formulas

Comments

Shaine Greenwood

Hello,

We currently don't have a way to validate data directly in a form. When you have a moment, please submit a Product Enhancement Request and let our Product team know that you'd like to have this functionality added to Smartsheet forms.

With that being said, once workaround you could try is—if you have a set number of options, try changing your Text/Number columns into Dropdown list columns and restricting values only to the Dropdown list options. More information on this is available in the help center: https://help.smartsheet.com/articles/504619-column-types

Dennis A. Garcia

This is will be a plus factor in form. I am tired of telling the sales to only provide numbers on the amount field. They keep messing my formula i put in the smartsheet. Having a validation is the best approach to prevent it from happening.

Moses Ali

I'm not sure if a solution was ever found for this. I have a simiar requirement. My work around whilst inelegant worked. I used a drop down single menu. Copied and pasted from excel 350 numbers which took seconds. So not great but it is working. If any data vaialdation updates have been provided plese let me know as I can't find a post in the community. thanks

Sign in to join the conversation!

Quick Links

Trending discussions

Break Up Multi-Entry Row
I'm using a form entry (into an Intake Sheet) in which someone can select multiple locations for the same Initiative. I'm looking to copy the row to a different Master sheet, but would like to have the same row copied multiple times, once per location selected. Intake Sheet: Desired Result in Master Sheet: Basically, I…
Set contents of two columns into 1
Hi - trying to figure out a formula that combines two columns into one long column, maintaining contents in multiple rows. Noting that the number of items in each column will change as these are each using the index/distinct to summarize a separate sheet. For example: Thanks for any help!
Unparsable formula; Sheet summary SUMIF formula
Can anyone help why this formula is coming up as unparseable? I'm creating a sheet summary, where it totals the Estimated GP (Est. GP) column if the Status column has the "Quoted" drop-down option is selected. Formula i've used: =SUMIF(Status:Status,"Quoted",Est. GP:Est. GP) Thanks a lot!