keeping information current / between two sheets


I have several worksheets, one being the master.

I have figured out how to "copy" a line from one to the other, but when that line changes, it does not update the other sheet.

How do I ensure the two stay in sync?

as an example - in the secondary sheet, the line changes from planned to completed, but that change is not reflected in the master sheet.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!