Inserting/Creating a Row Automatically

Bethany Garcia

Is there any way to automatically create/insert a row into a sheet based on a trigger from within that sheet? Essentially, copy a row of a sheet and paste it as a new row into the sheet with a different status or different value in a few columns?

Andrée Starå

Hi @Bethany Garcia

I hope you're well and safe!

Would it work if it was added as the last row?

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Bethany Garcia

I hope you're well and safe!

Would it work if it was added as the last row?

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Bethany Garcia

@Andrée Starå Yes, adding it as the last row would be sufficient.

Bethany Garcia

@Andrée Starå I just wanted to check back to see if you know of a way to insert a new row to a sheet as an automation or formula.

Andrée Starå

Hi @Bethany Garcia

I hope you're well and safe!

How did it go? Did you manage to get something set up?

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

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

Bethany Garcia

I did get it working, thank you for your help!

Andrée Starå

@Bethany Garcia

Excellent!

You're more than welcome!

James John Wilson

Can you able to provide the solution?

Michael Chohrach

@Bethany Garcia @Andrée Starå

I would be interested to see how this was accomplished.