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.

Possible to link subitems when linking cell?

Christina Dolan
Christina Dolan ✭
edited 12/09/19 inArchived 2015 Posts

Hello,

I am looking for a way to link a row and the sub-items of that row so our VP will have a sheet with all of our projects and their subphases/tasks while we can continue to maintains separate sheets for each project.

Thanks!

chrisitna

Tags:
· Share on Facebook Share on Twitter

Comments

  • Jim Hook
    Jim Hook ✭✭✭✭✭✭

    If your question applies to Gantt charts I'm not sure if this will work.

    I routinely link multiple indented rows/cells from individual project tracking sheets (not Gantt charts) into summary sheets for our managers to view without having to manually open and lok at up to 40 active projects. Since Smartsheet can link up to 500 cells per linking operation into a summary sheet, this is simple to setup. The only problem is that there is a limit of 5000 incoming links to a single sheet. If you have a lot of links on a lot of projects you may run into this limitation.

    · Share on Facebook Share on Twitter
  • Travis
    Travis Employee

    Christina, yes you can link parent and child rows (Task and subtasks) and it will be shown in the Gantt chart. When you first link the cells, they won't be indented but you can indent the rows once they are added to the destination sheet.

    Screen Shot 2015-12-01 at 2.54.16 PM.png

    · Share on Facebook Share on Twitter
This discussion has been closed.

Categories

You would set up conditions so that it will only send when Category is \"Project Name\" or Category is \"Objective\", so on and so forth then set up a \"custom message and only select the Category (if needed to provide context) and Description columns.<\/p>


<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

<\/p>


<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/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":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":109419,"type":"question","name":"Error When Importing Google Sheet","excerpt":"I was able to import this sheet successfully once as a test. Now when I try to import I get the attached error that states that the Excel file is invalid, but I didn't select to import and excel file! Any help would be appreciated!","snippet":"I was able to import this sheet successfully once as a test. Now when I try to import I get the attached error that states that the Excel file is invalid, but I didn't select to…","categoryID":321,"dateInserted":"2023-08-24T17:09:06+00:00","dateUpdated":null,"dateLastComment":"2023-08-24T20:30:09+00:00","insertUserID":165633,"insertUser":{"userID":165633,"name":"BudGarrison","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/BudGarrison","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-24T20:29:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":165633,"lastUser":{"userID":165633,"name":"BudGarrison","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/BudGarrison","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-24T20:29:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":28,"score":null,"hot":3385807155,"url":"https:\/\/community.smartsheet.com\/discussion\/109419\/error-when-importing-google-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109419\/error-when-importing-google-sheet","format":"Rich","tagIDs":[219,445],"lastPost":{"discussionID":109419,"commentID":392484,"name":"Re: Error When Importing Google Sheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392484#Comment_392484","dateInserted":"2023-08-24T20:30:09+00:00","insertUserID":165633,"insertUser":{"userID":165633,"name":"BudGarrison","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/BudGarrison","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-24T20:29:18+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/A73RHH8WRAUW\/capture-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.JPG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-24T20:30:03+00:00","dateAnswered":"2023-08-24T20:09:35+00:00","acceptedAnswers":[{"commentID":392473,"body":"

Is there any data in the source file?<\/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":219,"urlcode":"sheets","name":"Sheets"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}]},{"discussionID":109378,"type":"question","name":"How do I change the font (size and type) in a pie chart?","excerpt":"Hello, As per the attached screen shot, I am trying to change the size of the font (%ages) in the pie chart but unable to do so? I changed the font in the legend but not sure if it is possible to change it in the actual percentages? Please advise. Thanks","snippet":"Hello, As per the attached screen shot, I am trying to change the size of the font (%ages) in the pie chart but unable to do so? I changed the font in the legend but not sure if…","categoryID":321,"dateInserted":"2023-08-24T06:25:39+00:00","dateUpdated":null,"dateLastComment":"2023-08-25T05:29:52+00:00","insertUserID":158545,"insertUser":{"userID":158545,"name":"Safiya B","url":"https:\/\/community.smartsheet.com\/profile\/Safiya%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T05:28:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":158545,"lastUser":{"userID":158545,"name":"Safiya B","url":"https:\/\/community.smartsheet.com\/profile\/Safiya%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T05:28:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3385800931,"url":"https:\/\/community.smartsheet.com\/discussion\/109378\/how-do-i-change-the-font-size-and-type-in-a-pie-chart","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109378\/how-do-i-change-the-font-size-and-type-in-a-pie-chart","format":"Rich","lastPost":{"discussionID":109378,"commentID":392520,"name":"Re: How do I change the font (size and type) in a pie chart?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392520#Comment_392520","dateInserted":"2023-08-25T05:29:52+00:00","insertUserID":158545,"insertUser":{"userID":158545,"name":"Safiya B","url":"https:\/\/community.smartsheet.com\/profile\/Safiya%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T05:28:53+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-25T05:28:50+00:00","dateAnswered":"2023-08-24T09:55:27+00:00","acceptedAnswers":[{"commentID":392270,"body":"

@Safiya B<\/a> <\/p>

Sadly you are unable to change the label font and size. Have you tried changing to a Semicircle pie at all? That sometimes sorts out labelling issues!<\/p>

Kind regards<\/p>

Debbie<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&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":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts

  • Can an automation send particular cell information and not access to an entire column?

    We have projects set up in our Workspace. At the top of each sheet is Summary information from within the sheet and it's linking out to source sheets as well as information is pulling into the sheet from other sources. This is set globally through Control Center when a project is created. I would like to create an…

  • Error When Importing Google Sheet

    I was able to import this sheet successfully once as a test. Now when I try to import I get the attached error that states that the Excel file is invalid, but I didn't select to import and excel file! Any help would be appreciated!

  • How do I change the font (size and type) in a pie chart?

    Hello, As per the attached screen shot, I am trying to change the size of the font (%ages) in the pie chart but unable to do so? I changed the font in the legend but not sure if it is possible to change it in the actual percentages? Please advise. Thanks