combining sheets

smiller

Hi, everyone!

 

I would like to create a sheet or report that combines all of my other sheets so that I can look at them all together and sort by task.

Ideally, this "master sheet" would update as each individual sheet is updated.

Any help is appreciated!

 

Alison

Hello,

 

Thanks for reaching out and for this great question.  The best way to do this would be to create a Report that pulls from each of the sheets you want the data to pull from.  These will automatically update with data from those underlying sheets.

This can then be shared with other users and they'll see this same data as long as they have access to those underlying sheets.  If they do not have access to one of the underlying sheets, they'll see the data from only the sheets to which they have access.

Please let me know if you have further questions on this.

Kind regards,

Alison

Smartsheet Support