Moving Rows

Cinda.q

Hello-

Does anyone know if there is a solution for when rows are moved to another sheet via an automation to keep the 'Created by' field with the contact data versus stating the "automation@smartsheet"?

Thanks!

Andrée Starå

@Cinda.q

Happy to help!

Glad to hear it, and yes, same here.

You'd only need to add something like this.

=[Created By]@row

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support 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!

Andrée Starå

Hi @Cinda.q

I hope you're well and safe!

You could add a so-called helper column in the source sheet to store the original information.

Would 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 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!

Cinda.q

Andree-

All is great! Hope you are well too.

Thanks for confirming my thought on this. Do you have any recommendations on formulas to extract that data from the auto-system column for a 'Created by' field?

Andrée Starå

@Cinda.q

Happy to help!

Glad to hear it, and yes, same here.

You'd only need to add something like this.

=[Created By]@row

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support 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!

Cinda.q

Thanks again for the assistance Andree!

Andrée Starå

@Cinda.q

You're more than welcome!