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.

External References

Sherry Hagemeier
Sherry Hagemeier ✭
edited 12/09/19 inArchived 2015 Posts

Hello,

I would like to create two separate sheets where in the second sheet I can make reference to cells in the first sheet. Is this possible and if so, will the data update automatically in sheet 2 when sheet 1 is altered.

Thanks.

Sherry

Tags:
· Share on Facebook Share on Twitter

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 11/25/15

    Sherry,

    Quite easy.

    See this article for the full details:

    http://help.smartsheet.com/customer/portal/articles/861579

    Quick description:

    right click on a cell, select "Link from Cell in Other Sheet...." and follow the prompts.

    Everything else (and there's some cool stuff there) is just icing on the cake.

    表可以设置“流”两种方式s - overview sheets sees actuals/current values while task or schedules see the estimated values from above.

    Lots of useful videos on the subject too.

    Hope this helps,

    Craig

    · 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