@PeggyLang<\/a> <\/p>Happy to help!<\/p>
No, that should work as long as the sheet's permissions are okay.<\/p>
✅Remember! <\/strong>Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up\/Awesome or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-13 19:54:33","updateUser":{"userID":147369,"name":"PeggyLang","url":"https:\/\/community.smartsheet.com\/profile\/PeggyLang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-13T19:53:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":96499,"type":"question","name":"How do I override a row in a secondary sheet when the info is updated in the master sheet?","excerpt":"I have a Master sheet where all of the data is stored. I also have other secondary sheets that have just the applicable columns for those groups of people. When I update a date or cell in the master sheet, is there a way to either just update that same column in the secondary sheet with the new info or copy the entire row…","categoryID":321,"dateInserted":"2022-10-12T17:34:29+00:00","dateUpdated":null,"dateLastComment":"2022-10-13T18:35:17+00:00","insertUserID":151182,"insertUser":{"userID":151182,"name":"ajuelsgaard","url":"https:\/\/community.smartsheet.com\/profile\/ajuelsgaard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jD9qI_ZEy_o!ZBFrGdYxZ3o!BxiboRPb0pq","dateLastActive":"2022-10-13T18:53:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":151182,"lastUser":{"userID":151182,"name":"ajuelsgaard","url":"https:\/\/community.smartsheet.com\/profile\/ajuelsgaard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jD9qI_ZEy_o!ZBFrGdYxZ3o!BxiboRPb0pq","dateLastActive":"2022-10-13T18:53:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":33,"score":null,"hot":3331284586,"url":"https:\/\/community.smartsheet.com\/discussion\/96499\/how-do-i-override-a-row-in-a-secondary-sheet-when-the-info-is-updated-in-the-master-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96499\/how-do-i-override-a-row-in-a-secondary-sheet-when-the-info-is-updated-in-the-master-sheet","format":"Rich","tagIDs":[219,334],"lastPost":{"discussionID":96499,"commentID":347109,"name":"Re: How do I override a row in a secondary sheet when the info is updated in the master sheet?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/347109#Comment_347109","dateInserted":"2022-10-13T18:35:17+00:00","insertUserID":151182,"insertUser":{"userID":151182,"name":"ajuelsgaard","url":"https:\/\/community.smartsheet.com\/profile\/ajuelsgaard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jD9qI_ZEy_o!ZBFrGdYxZ3o!BxiboRPb0pq","dateLastActive":"2022-10-13T18:53:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-13T18:34:15+00:00","dateAnswered":"2022-10-12T18:33:32+00:00","acceptedAnswers":[{"commentID":346948,"body":"As far as copying the rows to the secondary sheet, what I do is just hide the unnecessary columns. Other than that you can just have vlookup or index\/match formulas in the columns on the secondary sheet to pull data from the first sheet.<\/p>"},{"commentID":346950,"body":"
So when you hide the columns on the secondary sheet, they stay hidden even when new rows are coming over.<\/p>
I do this both ways depending on how much data we're talking about. If I only need like 2 columns of data, I'll use INDEX\/MATCH.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-13 18:33:52","updateUser":{"userID":151182,"name":"ajuelsgaard","url":"https:\/\/community.smartsheet.com\/profile\/ajuelsgaard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jD9qI_ZEy_o!ZBFrGdYxZ3o!BxiboRPb0pq","dateLastActive":"2022-10-13T18:53:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":96475,"type":"question","name":"Connecting an Excel Sheet to a Smartsheet field?","excerpt":"Hello, Is there a way to create a drop-down field in a form, with values that come from an excel sheet? In other words, can you connect an excel sheet to a Smartsheet, and have dropdown values generated from that excel sheet? I need my users to be able to click on the drop-down field, start typing in a code, and have their…","categoryID":321,"dateInserted":"2022-10-11T22:22:14+00:00","dateUpdated":null,"dateLastComment":"2022-10-12T04:36:27+00:00","insertUserID":153427,"insertUser":{"userID":153427,"name":"cyarian","url":"https:\/\/community.smartsheet.com\/profile\/cyarian","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-12T15:45:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":116407,"lastUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2022-10-14T04:04:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":42,"score":null,"hot":3331076921,"url":"https:\/\/community.smartsheet.com\/discussion\/96475\/connecting-an-excel-sheet-to-a-smartsheet-field","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96475\/connecting-an-excel-sheet-to-a-smartsheet-field","format":"Rich","lastPost":{"discussionID":96475,"commentID":346859,"name":"Re: Connecting an Excel Sheet to a Smartsheet field?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/346859#Comment_346859","dateInserted":"2022-10-12T04:36:27+00:00","insertUserID":116407,"insertUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2022-10-14T04:04:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-12T14:21:29+00:00","dateAnswered":"2022-10-12T04:36:27+00:00","acceptedAnswers":[{"commentID":346859,"body":"
@cyarian<\/a> You would need to use Smartsheet's premium app Data Shuttle to do this.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-12 14:21:29","updateUser":{"userID":153427,"name":"cyarian","url":"https:\/\/community.smartsheet.com\/profile\/cyarian","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-12T15:45:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
Andrée Starå ✭✭✭✭✭✭
Jenna123 ✭
