Saving a template set with a workflow to destination sheet dynamically

melimob

Hi, I have a created a folder with sheets, reports and dashboards.

within this folder, there is a 'destination sheet' to which a workflow on another sheet should copy rows over once 'X' criteria is met.

From this 'destination sheet' I have reports running for my dashboard.

My question is, if I was to resave this whole folder and select 'save to newly created sheets', will the workflow 'Copy Row' flow in to the 'new destination sheet' within the 'new folder' or would I have to change the destination source each time?

many thanks

kowal

hi @melimob,

it will be still copying the row to the old sheet.

you will need to change the destination each time.

melimob

that's what I thought but was hoping there was a different answer ;))

I just wanted to avoid having to recreate the whole thing in a metric sheet but seems I will have to (we don't have dynamic view).

Thank you @kowal for your confirmation tho.

melimob

or, have the user change the filters in the report

or have them update the workflow

I ruled these two options out as I don't want to give them more than editor access and they are new to SS.

kowal

if you ever decide to go for Control Center it will resolve this problem.

melimob

understood thank you.