Can I have an IF/Then Statements on drop downs?
For example, I'm having people fill out a form when requesting creative assets (video/audio).
If they select a specific resolution from a drop down, then I only want certain video lengths to show that apply to that resolution only (this is also another drop down).
Or another example:
If a certain creative title is selected from a drop down, then I only want the only video options available to that creative to only show as options from another drop down that I have set up in a column.
Please let me know if the above makes sense, or if I can provide more detail.
Thanks,
Jay Duque
Best Answer
-
Hi Jay,
Unfortunately, it's not possible at the moment to use logic in forms, but it's an excellent idea!
(Smartsheet is rumored to be working on it)
Please submit an Enhancement Request when you have a moment.
As a workaround, you could use a third-party service like Google forms or similar. Is that an option for you?
I hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
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.
Answers
-
Hi Jay,
Unfortunately, it's not possible at the moment to use logic in forms, but it's an excellent idea!
(Smartsheet is rumored to be working on it)
Please submit an Enhancement Request when you have a moment.
As a workaround, you could use a third-party service like Google forms or similar. Is that an option for you?
I hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
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.
-
@Andrée Starå Thank you. I've gone ahead and submitted an enhancement request. Thanks for answering my questio so quick. I appreciate it.
Jay Duque
-
Excellent!
Happy to help!
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.
-
This will be possible in Smartsheet soon.
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 work?
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 443 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 129 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!