Copied Rows Randomly Placed in Blank Rows Below Target Sheet Content

Robert Mann

Can someone at Smartsheet please tell me why copied rows are placed at the bottom of the target Sheet with multiple blank rows of separation? I would like to know the intent of the product team from the standpoint of user experience. Thank you.

Andrée Starå

Hi @Robert Mann

I hope you're well and safe!

It shouldn't, but if there are "activated" rows, they would be added after them

Try deleting all the blank rows in the target sheet and see if that makes a difference.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

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

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

Summer Edwards

Summer Edwards

Hello @Andrée Starå. Regarding the above question in a copy rows automation, what if the target sheet has a column (not in source sheet) that has a formula in the cells that utilizes the copied over rows? When the automation runs, the rows import in below the rows that have this formula in them. Is there any way to correct this issue? Thanks in advance!

Summer