Pull Data from multiple sheets for a responsible team into a single sheet

D_E_

Hey Community,

Hoping to get a bit of help. I have 36 sheets that are all active. Each of these sheets has tasks assigned to multiple teams. I need to pull tasks for one team from all 36 sheets into a single sheet. I can't do this into a report because the hope is to link to google calendar. Since reports can't link to calendar it will have to be into a sheet. I also want this info to be updated live. So if a task is added it will be updated automatically. I am open to any ideas to make this happen!

Thanks!

Razetto

@D_E_ Hi, Have you looked into using DataMesh? You can have a master sheet that pulls from many other sheets by setting up multiple configurations. You can define how often the configuration is to run, meaning how often the info is updated in your master sheet.

https://help.smartsheet.com/learning-track/integrations-and-add-ons/datamesh