Dynamic View- How do you change the source sheet in the copy?
It would be great if you can change the "source sheet or report" in Dynamic view.
Even when you make a copy, it won't allow you to change the source sheet.
You click on the link to the source sheet and it sends you to the sheet for view and not to change it out.
Use case need- Dynamic view copy:
- I have 3 Business units and 3 Dynamic views set up for each Business unit based on filters I created
- They are all using the same source sheet - 2021 pipeline.
- I need to change the source sheet to 2022 pipeline source sheet. The source sheets have identical information. The dynamic views, details, and sharing information is the same as well.
Does anyone know how to do this without having to recreate the Dynamic views?