Cell linking and updating a column

I have a master sheet that contains a column called "Product Family." This master sheet is updated weekly, and some of the Product Family rows change - added or deleted.

The cells in the Product Family column on the master sheet are linked to another worksheet (called "Curation Audit") - also in a "Product Family" column.

I need changes to the Master Sheet's Product Family column to update the Curation Audit by removing any deleted rows and adding any new rows.

Is it possible to automate this process? Right now, I have to delete all the cell links, delete the column then add the column back, and insert the cell links again. This then breaks all of my formulas, which have to have all the #REF errors in them fixed. At 1500 rows of data, this is not a sustainable process.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!