INDEX/MATCH a good fit for updating a cell on another sheet?

cjbill8872

I'm using Smartsheet as a work order tracking system. Right now, I have a source sheet copying particular rows over to several child sheets based on the dropdown value of a column. I've experimented with moving rows back to the source sheet from the child sheets once modified, but it gets hairy because duplicates are created which require additional automations to clean up. What I'm wondering is if INDEX/MATCH is a good candidate that will allow the editor of the child sheet to update a particular cell in a row, and have that same cell in the same row updated on the source sheet?

SteyJ

https://community.smartsheet.com/discussion/130241/index-match-a-good-fit-for-updating-a-cell-on-another-sheet

Hello @cjbill8872,

It's a great option, just index/match based on the Ticket ID!