Linking data from multiple sheets to one master sheet - then to a dashboard

alex.winter

Context: I have a team of people with their own individual smartsheet trackers that each contain identical columns. I want to have the rows on those individual trackers automatically populate/update in one master tracker where I can see everyone's data at once.

I have already tried reports - this doesn't work for me. The intention with the master tracker is to be able to use that data to create metric widgets on a dashboard. Example, each individual tracker has a sheet summary formula that calculates unique vendor count - I want a master tracker that automatically updates as each person makes updates to their individual trackers, and uses the same formula to give me one total vendor count so that I can use that number for a widget on a dashboard - and I need it to be able to auto populate as more vendors are added, in turn increasing the count.

Yvonne Smythe

Hi @alex.winter - Have you tried adding a workflow to each sheet to have new/edited/updated rows moved or overwritten on a master sheet?