Copy & Duplicate pack of sheets/Folders

Waleed
Waleed ✭✭✭
inSmartsheet Basics

Hi ,

I have number of sheets to collect data periodically on monthly basis with own automation/task and work flow and many of sheets are linked and reading data from source sheets .

The above folders/sheets i create them every month using template function creating the sheets , and linking them again / rename it every month which is a time consuming/waste

I was wondering if its possible to clone or duplicate group of linked/customized files and folders with all our workflow setup instead of creating the sheets from single template/and doing our setup one by one

Thank you

Tags:
· Share on Facebook Share on Twitter

Answers

Categories

@BStump<\/a> <\/p>

This method does produce separate reports:<\/p>

The Project Plan report will include this filter: \"Sheet Type\" is one of \"Project Plan\" -- this filter will exclude rows coming from the RAID Log (and all other types of sheets) because those other sheets will have a value in their \"Sheet Type\" column that is not \"Project Plan.\" <\/p>

The RAID Log report will include this filter: \"Sheet Type\" is one of \"RAID Log\" -- this filter will exclude rows coming from the Project Plan (and all other types of sheets) because those other sheets will have a value in their \"Sheet Type\" column that is not \"RAID Log.\" <\/p>

Thus, each report will include a filter rule specifying that only rows with its own sheet type can be included.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":[{"tagID":265,"urlcode":"Reports","name":"Reports"}]},{"discussionID":108415,"type":"question","name":"Creating Check out\/in sheet and form?","excerpt":"Is it possible to create a check out\/in sheet and form where the entries from the form will land on the same row? I want to create a form where people can check things out\/in on the same date. So I'd check things out the in the morning of 8\/2 and check them in at closing time. I want all the data to land on the same row so…","snippet":"Is it possible to create a check out\/in sheet and form where the entries from the form will land on the same row? I want to create a form where people can check things out\/in on…","categoryID":321,"dateInserted":"2023-08-02T13:59:28+00:00","dateUpdated":null,"dateLastComment":"2023-08-02T14:53:22+00:00","insertUserID":155551,"insertUser":{"userID":155551,"name":"mistone","url":"https:\/\/community.smartsheet.com\/profile\/mistone","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-02T15:19:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":126800,"lastUser":{"userID":126800,"name":"Kelly P.","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-02T16:17:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":13,"score":null,"hot":3381973370,"url":"https:\/\/community.smartsheet.com\/discussion\/108415\/creating-check-out-in-sheet-and-form","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108415\/creating-check-out-in-sheet-and-form","format":"Rich","lastPost":{"discussionID":108415,"commentID":388490,"name":"Re: Creating Check out\/in sheet and form?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388490#Comment_388490","dateInserted":"2023-08-02T14:53:22+00:00","insertUserID":126800,"insertUser":{"userID":126800,"name":"Kelly P.","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-02T16:17:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-02T15:19:19+00:00","dateAnswered":"2023-08-02T14:53:22+00:00","acceptedAnswers":[{"commentID":388490,"body":"

@mistone<\/a> <\/p>

Form entries cannot land in the same row. However, you could use a form entry to check out and then use an update request to check in. <\/p>

Hope this helps!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":108381,"type":"question","name":"SCC Blueprint - Customize Profile Data","excerpt":"Hello Smartsheet Community, I am working on creating a Blueprint in Smartsheet's Control Center. Would someone be able to help me understand the differences between the \"Cell Link\", \"One Time Write\", and \"Editable Value\" options when on the customizing profile data page in my Blueprint settings? I haven't been able to find…","snippet":"Hello Smartsheet Community, I am working on creating a Blueprint in Smartsheet's Control Center. Would someone be able to help me understand the differences between the \"Cell…","categoryID":321,"dateInserted":"2023-08-01T20:45:57+00:00","dateUpdated":"2023-08-02T11:44:42+00:00","dateLastComment":"2023-08-02T16:12:15+00:00","insertUserID":159822,"insertUser":{"userID":159822,"name":"RyanF","url":"https:\/\/community.smartsheet.com\/profile\/RyanF","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/XGSHEPORDR99\/n8IO7FYKW8JCE.jpg","dateLastActive":"2023-08-02T16:12:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":159822,"lastUser":{"userID":159822,"name":"RyanF","url":"https:\/\/community.smartsheet.com\/profile\/RyanF","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/XGSHEPORDR99\/n8IO7FYKW8JCE.jpg","dateLastActive":"2023-08-02T16:12:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3381916692,"url":"https:\/\/community.smartsheet.com\/discussion\/108381\/scc-blueprint-customize-profile-data","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108381\/scc-blueprint-customize-profile-data","format":"Rich","tagIDs":[466,579],"lastPost":{"discussionID":108381,"commentID":388528,"name":"Re: SCC Blueprint - Customize Profile Data","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388528#Comment_388528","dateInserted":"2023-08-02T16:12:15+00:00","insertUserID":159822,"insertUser":{"userID":159822,"name":"RyanF","url":"https:\/\/community.smartsheet.com\/profile\/RyanF","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/XGSHEPORDR99\/n8IO7FYKW8JCE.jpg","dateLastActive":"2023-08-02T16:12:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-02T16:12:18+00:00","dateAnswered":"2023-08-02T13:41:58+00:00","acceptedAnswers":[{"commentID":388472,"body":"

Sure thing Ryan. I will try to explain it as best as I can, but if you still have questions let me know.<\/p>

Cell Link<\/strong> - Links the cells together so that any time the source changes, the destination will also be updated. This is useful for keeping information updated throughout the life of the project as things change<\/p>

One Time Write<\/strong> - Exactly what it says it is. The information will be written into the cell one time, and no updates will occur as data changes on the source sheet<\/p>

Editable Value<\/strong> - People deploying projects from the blueprint will be able to edit the value for this field when setting up the project<\/p>

I hope that helps.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":[{"tagID":466,"urlcode":"control-center","name":"Control Center"},{"tagID":579,"urlcode":"blueprint","name":"blueprint"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":4904,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics

  • Row Report from Sheets in Workspace

    If I have a set of folders under a workspace with different type sheets. Some will be Project plans, others may be RAID/CRAID Logs, etc. Is there a way to create a row report of all the RAID/CRAID Logs only, and separate from a similar row report with all the Project Plan line items?

  • Creating Check out/in sheet and form?

    Is it possible to create a check out/in sheet and form where the entries from the form will land on the same row? I want to create a form where people can check things out/in on the same date. So I'd check things out the in the morning of 8/2 and check them in at closing time. I want all the data to land on the same row so…

  • SCC Blueprint - Customize Profile Data

    Hello Smartsheet Community, I am working on creating a Blueprint in Smartsheet's Control Center. Would someone be able to help me understand the differences between the "Cell Link", "One Time Write", and "Editable Value" options when on the customizing profile data page in my Blueprint settings? I haven't been able to find…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video