Set a maximum value in a form field

Jennifer Locke

Wondering if there is a way to limit a field in a form to a specific maximum number. If the maximum number we accept is 20, how can the field automatically reject an entry of 25 and not let the form be submitted? I cannot create a static dropdown, because its tracking a dollar amount which can vary wildly between 0 and 20 dollars.

We've converted a number of Google forms to Smartsheet and are running into issues with our population 'not reading' the helper text and causing frustration and complicating a simple process.

Thanks!

Mark Cronk

Hi @Jennifer Locke ,

Smartsheets can't do a real time check. A workaround is to create an update request automation that emails the submitter prompting them to change the value if it was greater than 25. Update forms are pretty painless for the user but it still another step.

Help?

Mark

Andrée Starå

Hi @Jennifer Locke

To add to Mark's excellent advice/answer.

Another option could be to use the Conditional Logic in forms to show a message if the value is over 25.

I'd recommend adding a condition for maybe 25, 26, 27, 28, 29, 30 (or what makes sense for the process), but I would combine it with Mark's suggestion of an Update Request for everything over 25.

Then you can minimize those that submit anyway, but if they do, they will get an update request to update the value.

The method above can also be structured so the submission wouldn't even be added to the main sheet if the value isn't correct by using a so-called helper sheet and move/copy row automation.

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!