Saving a template set with a workflow to destination sheet dynamically

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

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.