Copy a row automation links to New sheet during Save As for a folder
Options
Currently the Automation Copy a row doesn't link to new sheet when you save as a new for a folder with all sub folders, sheets, dashboards, and reports.
I have an automation to Copy a row from a metric sheet to a historical sheet to create a trend. I have a report linked to the historical and utilize it in a dashboard. When I copy that folder structure, everything else links appropriately but not the automation copy a row. It stays linked to the original sheet.
I understand that it may be useful to have copy row go to the original sheet, but this should only be when the sheet isn't in the folder that is being copied.
