I have two tables:
- A list of tasks
- A list of projects
I’m looking to build a master table that I can filter to a project while editing the status of the tasks. The problem I’m facing is that my tasks table can change (grow and shrink) and I want each project to reflect those changes automatically.
I see threads that show solutions similar to what I’m hoping for with FormulaMap and AddRow, but these solutions appear to be a one time thing, and re-add all rows upon clicking again.
Does anyone have a strategy to accomplish this? Appreciate your thoughts!