Keeping rows updated once they are copied to another sheet.

Mr. G
Mr. G ✭✭
edited 11/09/22 in Formulas and Functions


I would like the rows I have copied into another sheet to be updated in real time or with a trigger or rule, without having to build an index/match cross sheet reference.

Here's a scenario for the context.

As Project Manager: I like to track multiple accounts in my sheets with multiple locations (every account/location being a row) for my personal timeline of things.

Management: builds a Master folder per account with one sheet, that contains multiple locations of that account.

So my PM rows end up in different Master folders so Management can track and do their own thing. I need a way to update thoses rows without creating new rows.

Simple Solution?

Thank you



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!