Interactive form
Currently I am having a form to collect the timesheet information from different 3rd party vendor. After receiving the data, I am creating a Timesheet smartsheet.
I have another master smartsheet which is the collection of all the purchase orders and keeping track of present status of the amount consumed.
Is it possible to make the first form interactive. like when the amount consumed is greater than the maximum allowed amount, the vendor will not be able to select that particular PO to submit the form.
If you see the attached figure, PO Number 4900675165 with line number 2 is not allowed to book further since all the amount is already consumed where as we are still able to book under 4900675165 with line number 3.
Thanks for the help.
Answers
-
Interactive forms with conditional logic is currently not available in Smartsheet. If you wanted to keep things strictly in Smartsheet, you could have logic built into "helper" columns on the sheet to send out update requests if something is incorrectly input.
Another option would be to use a 3rd party app such as Google Forms. This will provide your conditional logic, and Google Forms integrates very easily and seamlessly with Smartsheet.
-
This might help the process. ?
We will soon introduce two major enhancements to Smartsheet forms that we’d like you to know about in advance:
- A more immersive builder UI to help get the most out of your forms, faster
- Conditional logic to ensure each respondent is asked the most relevant questions
All of your existing forms will continue to work and be fully editable in the new builder.
Learn more about the update here.
Would that help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post 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.
-
Perfect Andree.
Waiting for the updates to come.
-
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.
-
I saw that email as well, and I am certainly looking forward to it.
But will it be able to read the sheet and provide logic based on that (remove option to select based on status of another field), or is it limited to only showing certain fields when certain options are selected kind of thing?
-
Woho! It's live now!
😀
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives