How to insert/delete a row that is in between two rows that have links to another sheet?

Options

I am working on a project with a "customer view" that links to the "master sheet". When a customer fills out information into their sheet, the information is linked/filled into the master sheet using the linking process. I am trying to figure out how to add a row in between or delete if necessary without changing the linking information. We have found that when inserting a new row, the information changes because the row for that specific item moves, in turn changing the link to the row below it.


Is there a better way of doing this? Trying to not have to add or delete a row from both the customer view sheet and the master sheet if possible. I have explored the parent/children cells, but haven't used it in the sheet yet in hopes there are other suggestions.


Thank you!

Answers

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

    Hi @rwebster

    I hope you're well and safe!

    You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.

    You'd use the Auto-number column in the Source sheet and then add a so-called Helper Column in the Destination sheet and manually add the same numbering for as many rows as you need.

    Make sense?

    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 support the Community by marking it Insightful/Vote Up 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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!