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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!