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.

linking cell data across multiple sheets to capture changes made on master sheet

Tanya Watts
Tanya Watts ✭
edited 12/09/19 inArchived 2015 Posts

ex.

Master Sheet - all changes, updates and final information

Trailer Sheet - info from Master gets copied to trailer

Avail Sheet - info from Master gets copied to avail

Is there a way I can ensure that my data changes on the master sheet are rolling up on the alternate sheets that house the same data?

Thank you

Tanya

Tags:
· Share on Facebook Share on Twitter

Comments

  • BobbyLite
    BobbyLite ✭
    edited 03/04/16

    As long as your cells are linked, you can rest assured knowing the changes will be reflected in the destination sheets. If you add new rows, you will need to link them manually (it won’t auto link new rows). You might be able to usereportswhich will automatically bring in rows from multiple sheets into a single report based on criteria your specify.

    · Share on Facebook Share on Twitter
  • Jim Hook
    Jim Hook ✭✭✭✭✭✭

    When you are viewing your master sheet and someone makes a change to one of your trailer sheets you will see a notification that cell link has made updates to the sheet. Just refresh the master sheet to see the changes. I have sheets linked several layers deep and it takes a few seconds for a change on the first sheet to ripple through all the others to reach a summary sheet. One of the convenient features of Smartsheet linking is that if you drag and drop a row on your master sheet to a different location all the links move with it.

    · Share on Facebook Share on Twitter
  • Tanya Watts
    Tanya Watts ✭

    Thanks to you both!

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

Categories

What type of plan are you on? Certain plan types require that a system admin give you permission to access group management.<\/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":[]},{"discussionID":109217,"type":"question","name":"Formula Help","excerpt":"I am trying to fix a formula. What I am trying to achieve is the number of days between the Assigned Date and the Created Date. The \"Executed\" is for when the status changes to Executed. I have a status column and date columns following for the statuses like \"Assigned\" , \"Pending\" etc. and for each status is a date column…","snippet":"I am trying to fix a formula. What I am trying to achieve is the number of days between the Assigned Date and the Created Date. The \"Executed\" is for when the status changes to…","categoryID":322,"dateInserted":"2023-08-21T17:53:13+00:00","dateUpdated":null,"dateLastComment":"2023-08-21T22:39:46+00:00","insertUserID":156010,"insertUser":{"userID":156010,"name":"AliT","url":"https:\/\/community.smartsheet.com\/profile\/AliT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!80tRN2Ch-HQ!nDHdH1rxiPw!1_-nYVqJJzq","dateLastActive":"2023-08-21T22:38:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":156010,"lastUser":{"userID":156010,"name":"AliT","url":"https:\/\/community.smartsheet.com\/profile\/AliT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!80tRN2Ch-HQ!nDHdH1rxiPw!1_-nYVqJJzq","dateLastActive":"2023-08-21T22:38:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":29,"score":null,"hot":3385301579,"url":"https:\/\/community.smartsheet.com\/discussion\/109217\/formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109217\/formula-help","format":"Rich","lastPost":{"discussionID":109217,"commentID":391751,"name":"Re: Formula Help","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/391751#Comment_391751","dateInserted":"2023-08-21T22:39:46+00:00","insertUserID":156010,"insertUser":{"userID":156010,"name":"AliT","url":"https:\/\/community.smartsheet.com\/profile\/AliT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!80tRN2Ch-HQ!nDHdH1rxiPw!1_-nYVqJJzq","dateLastActive":"2023-08-21T22:38:39+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-21T22:39:50+00:00","dateAnswered":"2023-08-21T22:31:14+00:00","acceptedAnswers":[{"commentID":391749,"body":"

Give this a try:<\/p>

=TODAY() - IF([Assigned Date]@row <> \"//www.santa-greenland.com/community/discussion/318/\", [Assigned Date]@row, DATEONLY(Created@row))<\/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":109212,"type":"question","name":"INDEX MATCH with multiple values question","excerpt":"Hello, I have 2 sheets. Response Form Assignment tracker Both sheets have the same following columns: Evaluator Name Candidate Name I have a check box column in Assignment Tracker that I'd like to check off if the Candidate name AND the Evaluator name match in both sheets. There will be duplicate results for each column…","snippet":"Hello, I have 2 sheets. Response Form Assignment tracker Both sheets have the same following columns: Evaluator Name Candidate Name I have a check box column in Assignment Tracker…","categoryID":322,"dateInserted":"2023-08-21T17:26:43+00:00","dateUpdated":null,"dateLastComment":"2023-08-21T20:29:09+00:00","insertUserID":165425,"insertUser":{"userID":165425,"name":"MarcM","title":"","url":"https:\/\/community.smartsheet.com\/profile\/MarcM","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-21T20:24:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-22T00:53:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":28,"score":null,"hot":3385290352,"url":"https:\/\/community.smartsheet.com\/discussion\/109212\/index-match-with-multiple-values-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109212\/index-match-with-multiple-values-question","format":"Rich","lastPost":{"discussionID":109212,"commentID":391719,"name":"Re: INDEX MATCH with multiple values question","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/391719#Comment_391719","dateInserted":"2023-08-21T20:29:09+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-22T00:53:34+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-21T20:28:55+00:00","dateAnswered":"2023-08-21T19:17:27+00:00","acceptedAnswers":[{"commentID":391690,"body":"

I think I would just use a COUNTIFS in this situation:<\/p>

=IF(COUNTIFS({FY24 Hirevue Response Sheet Range 1}, [Evaluator Name]@row, {FY24 Hirevue Response Sheet Range 2}, [HV Candidate Name]@row) > 0, 1, \"//www.santa-greenland.com/community/discussion/318/\")<\/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":[]}],"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

  • Creating a contact group in Smartsheet?

    嗨,我想创建一个联络小组(即组织p of collaborator emails). I came across a Help post that instructs me to click on the Account Icon and select "Group Management", however, when I click on the icon, I don't have that option. If I select "My Smartsheet Contacts", there is also no option to create contact…

  • Formula Help

    I am trying to fix a formula. What I am trying to achieve is the number of days between the Assigned Date and the Created Date. The "Executed" is for when the status changes to Executed. I have a status column and date columns following for the statuses like "Assigned" , "Pending" etc. and for each status is a date column…

  • INDEX MATCH with multiple values question

    Hello, I have 2 sheets. Response Form Assignment tracker Both sheets have the same following columns: Evaluator Name Candidate Name I have a check box column in Assignment Tracker that I'd like to check off if the Candidate name AND the Evaluator name match in both sheets. There will be duplicate results for each column…