Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
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
