Automation workflow to Copy rows to a destination sheet

bday2329

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

bday2329

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

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!