Update a copy row

Options
Desertbird
Desertbird ✭✭
edited 07/28/22 in Formulas and Functions

Hello,

I have a form that is feeding a master sheet, with an automation to copy rows to separate sheets assigned by state.

I'm looking for a way to update the information so that it stays consistent on the master sheet and the separated sheet where the row was copied to.


The only solution I can think of is to have an update request automation on the master sheet, and another automation to copy again when it changes, but that would leave two records instead of just the updated one. Is there any way to avoid that so it is just one row per submission, even if an edit is needed?

Answers

  • Kiela
    Kiela ✭✭✭✭
    Options

    Hi,

    I too had the same issue, the sheets generally have a one-way flow. After talking to someone at Smartsheet I was advised I would need to have the Data Shuttle licence to be able to do the same thing as you are after.


    KL

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

    Hi @Desertbird

    I hope you're well and safe!

    Do you only need to be able to update the Source sheet and then have that reflected on the Destination sheet?

    I hope that helps!

    Be safe and have a fantastic weekend!

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Gita Mooney
    Gita Mooney ✭✭✭
    Options

    To answer this comment -

    I too had the same issue, the sheets generally have a one-way flow. After talking to someone at Smartsheet I was advised I would need to have the Data Shuttle licence to be able to do the same thing as you are after.

    When you do use the Data Shuttle, it does not update attachments, comments etc. Just FYI

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!