Set a maximum value in a form field
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.
Help Article Resources
Check out the Formula Handbook template!