Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

External References



I would like to create two separate sheets where in the second sheet I can make reference to cells in the first sheet.  Is this possible and if so, will the data update automatically in sheet 2 when sheet 1 is altered.







  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 11/25/15



    Quite easy.

    See this article for the full details:




    Quick description: 

    right click on a cell, select "Link from Cell in Other Sheet...." and follow the prompts.

    Everything else (and there's some cool stuff there) is just icing on the cake.


    Sheets can be set up to 'flow' both ways - overview sheets sees actuals/current values while task or schedules see the estimated values from above.

    Lots of useful videos on the subject too.


    Hope this helps,




This discussion has been closed.