Making sheets from a sheet
I know how to copy info from one sheet to another sheet. My question is...I've created an Application form for my employees to fill out. Is there a way to set up where a new sheet is created for each applicant and copies their info to it also. Meaning...Joe Smith fills out my application - then Smartsheets creates a brand new sheet just for Joe Smith - that will fill in his name, address, etc on the new form. Then a new form for Betty Boop, etc.
Thanks!
Answers
-
Hi @JMJ70,
I don't believe there is a way to do that, where a completed Smartsheet form creates a brand new grid sheet for the user with restricted view just for the user.
Would Update Request work for your application? You could set a trigger when a form is completed, for an update request to be sent to the user immediately after submission, asking for their details (name, address, etc), which would all feed into the same row of your grid sheet. You can then use Report to Filter for Current User, where they can only view their details and theirs alone.
Cheers,
Ric
-
Thank you for the ideas! I'm going to try that trigger/filter method I think that'll work. Cheers!
John
-
Happy to assist!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!