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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!