Moving Rows

04/07/21
Accepted

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 "[email protected]"?


Thanks!

Best Answer

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    edited 04/07/21 Accepted Answer

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

    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.

Answers

  • Andrée Starå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!

    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.

  • Cinda.qCinda.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åAndrée Starå ✭✭✭✭✭
    edited 04/07/21 Accepted Answer

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

    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.

  • Cinda.qCinda.q ✭✭✭✭✭

    Thanks again for the assistance Andree!

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Cinda.q

    You're more than welcome!

    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.

Sign In or Register to comment.