Forms and manual addition to Sheet
Good afternoon,
I have a tricky question. I have designed a form to create a dynamic drop-down experience using columns for each option (kept hidden) and then using a column Join formula in a helper column to collate the results (visible). The issue I will come across is there will be users who will opt out of using the form to add their own info, manually. Is it possible to have my helper column also be a drop-down for manual selection?
The column in green is the one I would like to have both the Join function and an available drop-down. Is it possible to leave them this way or is there another workaround?
Best Answer
-
Hey @Brandon R,
Unfortunately if you use a column formula, that column can't be used for any manual data entry (you can actually confirm this if you go into your form editor and try to add a column that has a column formula; you won't see it as a field that can be added).
Would it be possible to restrict the sheet access to view only for users, and only allow them to enter data via the form?
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
Answers
-
Hey @Brandon R,
Unfortunately if you use a column formula, that column can't be used for any manual data entry (you can actually confirm this if you go into your form editor and try to add a column that has a column formula; you won't see it as a field that can be added).
Would it be possible to restrict the sheet access to view only for users, and only allow them to enter data via the form?
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
-
That's what I was afraid of. I've updated instructions to the team to let them know to submit using the form and we'll make changes as needed. Thanks @bisaacs for replying.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!