At location this week, this month

ajlahti

I have created a SmartSheet Travel and Resource calendar where my organization logs in their travel dates, to which operational sites we visit, etc.

Each team in the organization has its own sheet, but a dashboard consolidates the information.

How can I build a table in the dashboard, that dynamically updates, to show who is at what site this week/month/site?

S.Stone

I'd use a combined report that pulls from each of the source sheets. Once the combined report has all of the columns and filters you want, you can group it (and/or save copies of the report to view different views - perhaps one per department, one per site, etc.).

Reports update automatically as the tables update, so the dashboard will show that live information from these reports.