External References

Sherry Hagemeier

Hello,

 

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.

 

Thanks.

 

Sherry

J. Craig Williams

Sherry,

 

Quite easy.

See this article for the full details:

 

http://help.smartsheet.com/customer/portal/articles/861579

 

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,

 

Craig