Form Logic, Restrictions & Evaluating
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
-
Hi @Mike Rini
Yes, there is. You can use another column and add a default message that would show thru the Form Logic feature.
I hope that helps!
Be safe and have a fantastic week!
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
That makes sense - how do I calculate 1,000 / 30 days? Is there a way in the logic I'm not seeing / thinking of
-
Apologies, I missed the part with the calculation of days.
Unfortunately, that won't work.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!