Creating a form with Multiple Logics
I have a very large worksheet - almost 80 columns wide. Of those, about 20 are formula "Only" columns where personnel will not enter data.
I would love to use the same form, select from the drop down and the fields auto-populate. But I am getting this error.
Is there a limit? Or is the error because I am selecting the same columns for the most part? Asking for an enhancement so that this will work best.
My only option is to create separate forms based on the treatment selected.
Answers
-
I believe you could still use one form for this, but you'd need to break up your statement so that not all of the columns are dependent on this one selection.
For example, have this one selection bring up the first 10 columns related to that choice. Then when the 10th column is filled out, have a new rule for the next 10 columns related to that choice to pop up. Since that 10th column is only visible from the first selection, these options won't show if something else was picked at the beginning. Does that make sense?
The second-to-last bullet point in our Help Center goes through this type of "nested logic" which should help your form to process (see here).
Hope this helps!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Thank you! I will try that!
-
No problem! Let me know if it works 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives