Linking Two Sheets to update dynamically When columns are added and removed.

10/28/19 Edited 12/09/19

I have two sheets that i want to be linked dynamically. EX:

Column 1:

1

2

3

4

5

 

I want to be able to have this column automatically update and be created on the second sheet when it is changed on the first. If for example, I were to add in a row between two and three with a value of 2.5, I would like this to update on Sheet 2. Currently i just have them linked in a manner that will only update that information if there was already a row in place or an empty row. It, however, will not update new rows that are added or rows that are removed for various reasons. Any idea how to set up a formula that will automatically pull all data points in this column and Create/remove rows as needed in sheet2?

Comments

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

    Hi Matt,

    It sounds like we could use cross-sheet formulas or cell-linking to make this work.

    Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    I hope that helps!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    work-bold

    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 shared the Links and sent you an email with more details. What I am looking for is a more accurate cell linking that will update when rows are added/removed if that is possible. 

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

    Thanks!

    I'll take a look and get back to you!

    Best,

    Andrée

    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.

  • Sherry XuSherry Xu ✭✭✭✭✭

    Any updates on this?

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

    Hi @Sherry Xu & @Matt Penta

    I'd be happy to share an example. 

    Please send me an email at [email protected], and I'll share it with you.

    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 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.

Sign In or Register to comment.