Keeping rows updated once they are copied to another sheet.
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.
Help Article Resources
Check out the Formula Handbook template!