Combining Sheets

Dawn_ATX
Dawn_ATX ✭✭✭
inShow & Tell

Hello Community! Wondering if anyone out there has any best practices for combining a project plan and a resource plan into one sheet. Is this an option? Would that sheet then be able to have the same functionality and link certain cells / info back into Resource Management? Right now, they are two separate sheets, but our engagement team said that it would be useful to see if we could combine them. Interested to hear your thoughts / feedback. Thank you!

Tags:
· Share on Facebook Share on Twitter

Answers

  • BullandKhmer
    BullandKhmer ✭✭✭✭✭

    My first thought is you might want to check and consider your sheet size limitations. Often sheets are split in two to manage limitations.

    Assuming that is fine you could probably use a simple index match function to add the data from one sheet to another. You would need matching ID's in each sheet to make this work so you would need to consider how to do that.

    Another option is to use a report, make sure to group ID & summarize the relevant fields, Your limited to 5 fields doing this though.


    Cheers,


    AJ

    · Share on Facebook Share on Twitter
  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi@Dawn_ATX

    I hope you're well and safe!

    I assume you're asking about the Legacy Resource Management feature.

    Have you explored the new Resource Management by Smartsheet? Is that an option?

    Be safe, and have a fantastic week!

    Best,

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    ✅了我的帖子(s)帮助或回答你的问题吗tion or solve your problem? Please support the Community bymarking it Insightful/Vote Up, Awesome, 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

    https://workbold.com/

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter

Categories

2023-06-29T00:03:58.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":108243,"type":"discussion","name":"Spouse","excerpt":"Who has had the biggest impact on your career and why? My spouse. They have been my #1 cheerleader, counselor, and consoler. Without their support for each new career move and advances in education, I would not be here. Sometimes this has represented itself in, \"Hey, I'll take care of the kids\" so you can....\" Other times…","snippet":"Who has had the biggest impact on your career and why? My spouse. They have been my #1 cheerleader, counselor, and consoler. Without their support for each new career move and…","categoryID":346,"dateInserted":"2023-07-28T13:03:09+00:00","dateUpdated":"2023-07-28T13:04:56+00:00","dateLastComment":"2023-07-28T13:03:09+00:00","insertUserID":159974,"insertUser":{"userID":159974,"name":"Kathy Nordeen","url":"https:\/\/community.smartsheet.com\/profile\/Kathy%20Nordeen","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bWND2xUYSns!-kDCd20oGWc!LupiVtZ_w3R","dateLastActive":"2023-07-28T13:03:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":159974,"lastUserID":159974,"lastUser":{"userID":159974,"name":"Kathy Nordeen","url":"https:\/\/community.smartsheet.com\/profile\/Kathy%20Nordeen","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bWND2xUYSns!-kDCd20oGWc!LupiVtZ_w3R","dateLastActive":"2023-07-28T13:03:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":15,"score":1,"hot":3381099185,"url":"https:\/\/community.smartsheet.com\/discussion\/108243\/spouse","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108243\/spouse","format":"Rich","tagIDs":[493],"lastPost":{"discussionID":108243,"name":"Spouse","url":"https:\/\/community.smartsheet.com\/discussion\/108243\/spouse","dateInserted":"2023-07-28T13:03:09+00:00","insertUserID":159974,"insertUser":{"userID":159974,"name":"Kathy Nordeen","url":"https:\/\/community.smartsheet.com\/profile\/Kathy%20Nordeen","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bWND2xUYSns!-kDCd20oGWc!LupiVtZ_w3R","dateLastActive":"2023-07-28T13:03:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell"}],"groupID":null,"statusID":0,"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":346,"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell","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":1}],"tags":[{"tagID":493,"urlcode":"qofmonth","name":"QofMonth"}]},{"discussionID":108228,"type":"discussion","name":"Certified!","excerpt":"No, not certifiable - CERTIFIED! I received my Core App skill and Core Product Certification.","snippet":"No, not certifiable - CERTIFIED! I received my Core App skill and Core Product Certification.","categoryID":346,"dateInserted":"2023-07-27T21:35:06+00:00","dateUpdated":null,"dateLastComment":"2023-07-27T23:36:37+00:00","insertUserID":164233,"insertUser":{"userID":164233,"name":"juliedesselle","title":"Senior Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/juliedesselle","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5_FHOTVnHv0!xMlHcaE7LTs!q9wCANfQlCb","dateLastActive":"2023-07-27T21:57:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":126614,"lastUser":{"userID":126614,"name":"Alison Clancy","title":"Community Engagement Manager II","url":"https:\/\/community.smartsheet.com\/profile\/Alison%20Clancy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nEFeH-a5APo!7Idee8avSzo!8w93-Gb3myE","dateLastActive":"2023-07-28T20:40:23+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":3380995303,"url":"https:\/\/community.smartsheet.com\/discussion\/108228\/certified","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108228\/certified","format":"Rich","lastPost":{"discussionID":108228,"commentID":387699,"name":"Re: Certified!","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387699#Comment_387699","dateInserted":"2023-07-27T23:36:37+00:00","insertUserID":126614,"insertUser":{"userID":126614,"name":"Alison Clancy","title":"Community Engagement Manager II","url":"https:\/\/community.smartsheet.com\/profile\/Alison%20Clancy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nEFeH-a5APo!7Idee8avSzo!8w93-Gb3myE","dateLastActive":"2023-07-28T20:40:23+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell"}],"groupID":null,"statusID":0,"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":346,"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell","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":108066,"type":"discussion","name":"Hello!","excerpt":"Hello, I'm new to the community. My name is Tiffany and I live in the Indianapolis area. I have been using smartsheets for almost 3 years and it has been a game changer. I LOVE smartsheets and I know I am only using a tiny percentage of its capabilities. I can't wait to learn all things smartsheets!","snippet":"Hello, I'm new to the community. My name is Tiffany and I live in the Indianapolis area. I have been using smartsheets for almost 3 years and it has been a game changer. I LOVE…","categoryID":346,"dateInserted":"2023-07-25T21:15:32+00:00","dateUpdated":null,"dateLastComment":"2023-07-26T15:47:47+00:00","insertUserID":163988,"insertUser":{"userID":163988,"name":"taschunn","title":"Sr. Manager, Compensation and Benefits","url":"https:\/\/community.smartsheet.com\/profile\/taschunn","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5T1ASS338R0S\/nZD12EK6Y00KD.jpg","dateLastActive":"2023-07-26T19:49:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161936,"lastUser":{"userID":161936,"name":"Rebeca S.","title":"Community Engagement Specialist","url":"https:\/\/community.smartsheet.com\/profile\/Rebeca%20S.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nqEp__PbH_o!bWcqW9OZSjo!5kR2l6b41gd","dateLastActive":"2023-07-28T21:52:55+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":31,"score":1,"hot":3380707699,"url":"https:\/\/community.smartsheet.com\/discussion\/108066\/hello","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108066\/hello","format":"Rich","lastPost":{"discussionID":108066,"commentID":387182,"name":"Re: Hello!","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387182#Comment_387182","dateInserted":"2023-07-26T15:47:47+00:00","insertUserID":161936,"insertUser":{"userID":161936,"name":"Rebeca S.","title":"Community Engagement Specialist","url":"https:\/\/community.smartsheet.com\/profile\/Rebeca%20S.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nqEp__PbH_o!bWcqW9OZSjo!5kR2l6b41gd","dateLastActive":"2023-07-28T21:52:55+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell"}],"groupID":null,"statusID":0,"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":346,"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell","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":1}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=346&includeChildCategories=1&dateInserted=%3E2023-06-29T00%3A03%3A58%2B00%3A00&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":20,"limit":3},"title":"Trending in Show & Tell","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">