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.

Sharing Data Between Sheets

Darold Turock
edited 12/09/19 in Archived 2015 Posts

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?




This discussion has been closed.