Separate form submissions from reference data
I've imported a CSV File into Smartsheet that serves as my database repository for Form Fields. My Form is created on this sheet in order to reference data values within the grid for multi-select form responses, which are limited to the values provided.
I would like for form submissions to land on a separate sheet as my database repository will need to be refreshed each month (we will be adding values). Is using Smartsheet automation to move fields every time a new row is added the best method, or are there any other methods that can be used or recommended?
Much appreciated!
Answers
-
Hi @cbeleno
I hope you're well and safe!
- I'd recommend adding the form to another sheet and then moving/copying the row(s) to the other sheet.
Make sense?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. 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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives