Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
Sheet scalability
我有一张我为year-en建造d performance reviews.
The sheet is designed for one person.
My company has 50+ employees and it would be great if I can run some sort of macro/app that would take the sheet and replicate it 50 times with each sheet adding a new name from a contact list.
Any ideas?
Thanks
Ian
Comments
-
You may want to consider turning your sheet into a form. Seeing an example would be helpful.
I have seen a Zapier (I believe) that generates a new sheet based on a trigger as well.
-
JamesR ✭✭✭✭✭✭Ian,
I am with Sarah, change the sheet to be for multiple people, do not share but send then the web form. If you want Conditional branching create a Google form which allows it anf it will create the smartsheet.
Use oogle docs to mail merge reports to document or PDF
Much better that 1 sheet per person.
James
-
Ian ✭
Each person has different goals on their performance reviews, so a webform wouldn't work
-
Travis EmployeeThis is definitely something Zapier and Azuqua can do! They can create sheets based off a trigger (such as adding data to a row). Once set up, if you add 50 names to 50 rows, 50 sheets could be created with the respective name included in each new sheet.
zapier.com
azuqua.com
-
J. Craig Williams ✭✭✭✭✭✭For my team, I created one sheet for me and the build a Report for each team member to view.
I would Save-New to keep the completed reviews and cleanup the sheet for the next period.
But I only had 12 reports.
Craig
Categories
Try this:<\/p>
=IF([Date of Site Survey (Product)]@row <> \"//www.santa-greenland.com/community/discussion/4925/\", IF(TODAY() > [Date of Site Survey (Product)]@row, \"yes\", \"no\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":106277,"type":"question","name":"Help creating formula to update inventory automatically","excerpt":"The following is our brochure requests sheet. Right now we manually update our inventory each time we receive a request. Here is a snapshot of the new inventory sheet. I'd like to create a formula that automatically subtracts 100 from Spanish Qty each time the Request Completed is checked, the Request Denied column is…","categoryID":322,"dateInserted":"2023-06-09T16:17:37+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T18:12:07+00:00","insertUserID":161705,"insertUser":{"userID":161705,"name":"Christina S.","url":"https:\/\/community.smartsheet.com\/profile\/Christina%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T18:07:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161705,"lastUser":{"userID":161705,"name":"Christina S.","url":"https:\/\/community.smartsheet.com\/profile\/Christina%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T18:07:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":36,"score":null,"hot":3372664184,"url":"https:\/\/community.smartsheet.com\/discussion\/106277\/help-creating-formula-to-update-inventory-automatically","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106277\/help-creating-formula-to-update-inventory-automatically","format":"Rich","tagIDs":[204,219,254],"lastPost":{"discussionID":106277,"commentID":379911,"name":"Re: Help creating formula to update inventory automatically","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379911#Comment_379911","dateInserted":"2023-06-09T18:12:07+00:00","insertUserID":161705,"insertUser":{"userID":161705,"name":"Christina S.","url":"https:\/\/community.smartsheet.com\/profile\/Christina%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T18:07:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/FMANSEYA9OS3\/mm-brochures-request-sheet-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"MM-Brochures-Request-Sheet.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T18:11:32+00:00","dateAnswered":"2023-06-09T17:51:51+00:00","acceptedAnswers":[{"commentID":379899,"body":"
