Form Logic, Restrictions & Evaluating

Options

I'm building a Form, and one of the criteria is Budget. I would like to evaluate the Budget field as they tab-off of it, before the form is submitted as I know there would be times people will enter an amount that won't be sufficient.

The scenario would be - the Budget is $1,000, but based on the number of calendar days, I know that it's too little immediately, I'd like to alert the person before submitting. In essence, when they enter the Budget, I use the Logic portion of the Field to flag something - a note, a field or something.

So, is there a way to handle this within the Form? I know I can manage it via sending an Update Request (with some calculation) after the Form has been submitted, but would prefer to check something upfront.

Thanks,

Mike

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!