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 "[email protected]"?
Happy to help!
Glad to hear it, and yes, same here.
You'd only need to add something like this.
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!
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
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!
✅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!
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?
Thanks again for the assistance Andree!
You're more than welcome!