Sharing Data Between Sheets

Darold Turock

Hello. New User Here.

 

I have reviewed reports and cell linking, however I have additional questions.

 

Here is the scenario.

 

Lets say I have 10 web design services clients.

 

I create a sheet for each one outlining the tasks that need to be done on their project.

 

I create a column that indicates a Y or N response (Y wouild be the criteria for that item to show up on a main sheet that collects data from all 10 clients) (N means it would not show up)

 

Can a create a Master Sheet that will display all the information from a selected set of sheets that meet certain criteria.?

 

For example, the main sheet will tell me which items have been marked Y and/or are overdue.

 

Can this be accomplish with cell linking or in some other formati?

 

Thanks

J. Craig Williams

Darold,

 

If I understand your needs correctly, reports should be able to consolidate your from the various sheets.

 

This article is a good place to start:

 

http://help.smartsheet.com/customer/en/portal/articles/522214-creating-reports

 

Craig