Auto update columns across sheets



I use a form to collect details from participants. This goes in a participants sheet (1).

The name and the country of residence (and none of the other collected information) I want to use in another sheet (2) and add some other columns of information to them. So I linked the the columns in the new sheet (2) to the sheet (1) that collects the information with the form.

I see the link indicated (little blue triangle) in the sheet (2) but when new names are added in sheet (1), the sheet (2) is not updated.

How can I make this update in sheet (2) happen?

Thank you for your help.


Best Answer


  • Victor van R

    Hi Andrée,

    Yes, I used cell linking.

    VLOOKUP. I will give it a try even though this spreadsheet knowledge is a bit rusty.

    Thank you for your help and have a good and safe weekend too!


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 06/29/20

    @Victor van R

    You're more than welcome!

    Let me know how it goes and if you have any questions!

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


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

    W: | | P: +46 (0) - 72 - 510 99 35

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