Automating Cell Link

I've created a workflow to handle project requests that come in to our department. We have a master sheet where all new requests are entered (either manually or from a webform) then each of our 3 team members have an individual sheet. When the new project is assigned, the row is copied to the individual's sheet (to whom it was assigned). <\/p>

Is there a way to automatically link the status and progress cell back to the master sheet so when a change is made to the individual sheet, the master sheet will change as well? I'd like to avoid having the individuals have to manually link cells every time they were assigned something. <\/p>

I'd even be happy with a replace function where the whole row was copied back to the master and replaces the original row (doesn't look like that exists).<\/p>

I do have approval automation set up for the status cell I'd just like to link cells as well to cover all bases.<\/p>

Thanks!<\/p>","bodyRaw":"[{\"insert\":\"I've created a workflow to handle project requests that come in to our department. We have a master sheet where all new requests are entered (either manually or from a webform) then each of our 3 team members have an individual sheet. When the new project is assigned, the row is copied to the individual's sheet (to whom it was assigned). \\nIs there a way to automatically link the status and progress cell back to the master sheet so when a change is made to the individual sheet, the master sheet will change as well? I'd like to avoid having the individuals have to manually link cells every time they were assigned something. \\nI'd even be happy with a replace function where the whole row was copied back to the master and replaces the original row (doesn't look like that exists).\\nI do have approval automation set up for the status cell I'd just like to link cells as well to cover all bases.\\nThanks!\\n\"}]","format":"rich","dateInserted":"2020-02-13T15:44:34+00:00","insertUser":{"userID":118628,"name":"John Beattie","url":"https:\/\/community.smartsheet.com\/profile\/John%20Beattie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-03-13T14:37:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/65988\/automating-cell-link","embedType":"quote","name":"Automating Cell Link"}"> https://community.smartsheet.com/discussion/65988/automating-cell-link

Hi,<\/p>

I am trying to auto-populate multiple cells (Linked to show real time changes) in however many rows necessary from another sheet. The workflow should link the info on the trigger of filling in a cell value in the source sheet. Is this possible?<\/p>

I understand I could set up a workflow to "move" a row, but this does not link the values, and I don't necessarily want all the columns transferred to the other sheet.<\/p>

Thanks!<\/p>","bodyRaw":"[{\"insert\":\"Hi,\\n I am trying to auto-populate multiple cells (Linked to show real time changes) in however many rows necessary from another sheet. The workflow should link the info on the trigger of filling in a cell value in the source sheet. Is this possible?\\nI understand I could set up a workflow to \\\"move\\\" a row, but this does not link the values, and I don't necessarily want all the columns transferred to the other sheet.\\nThanks!\\n\"}]","format":"rich","dateInserted":"2021-09-16T23:21:53+00:00","insertUser":{"userID":139995,"name":"Jenna123","url":"https:\/\/community.smartsheet.com\/profile\/Jenna123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/n65S9PRP4PA0M.png","dateLastActive":"2022-05-13T19:11:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/305297#Comment_305297","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/305297#Comment_305297