Automation workflow to Copy rows to a destination sheet

Good morning,

I have set up an automation workflow to copy a specific set of Rows to another sheet. The workflow works great however in the destination sheet I have column formula's that do not get inherited automatically. Is that the norm for the Copy row to another sheet function or is there something I am missing? See examples attached.

Source sheet

Auto workflow

Destination sheet after Copy of Rows function

Left side Red are rows copied, Red Circle are formula I want the copied rows to inherit, blue circle shows formulas were not inherited

Thank you in advance

Find more posts tagged with

Accepted answers

bday2329

Thanks Andree appreciate the quick response I set up column formulas and will test it out

All comments

Andrée Starå

Hi @bday2329

I hope you're well and safe!

I'd recommend using column formulas in the destination sheet because it won't work because you have parent and children levels.

Make sense?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

bday2329

Thanks Andree appreciate the quick response I set up column formulas and will test it out

Andrée Starå

@bday2329

Excellent!

You're more than welcome!

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.