Combined Projects

This page brings together project data from two separate Google Sheets: Jeslin's sheet and Joshua's sheet.

One view of your team's projects. Review customer names, project values, and confirmation status across Jeslin's and Joshua's sheets without manually copying rows or opening each spreadsheet. Source labels and links make it easy to trace each entry back to its owner.

What this demo shows: How separate team-maintained Google Sheets can feed a shared management dashboard, reducing manual collation and helping the CEO and team discuss projects using the same combined view. Contributors keep working in their own sheets; this dashboard is read-only and picks up changes on the next successful refresh. Matching projects are not merged, and values retain their source currency or units.

Project rows--
Confirmed (Yes)--
Source sheets--

Each person maintains their own Google Sheet. This read-only dashboard fetches both sheets and combines their project rows into one view. The Source column shows which sheet each row comes from; the original sheets remain separate.

Changes saved in either Google Sheet are picked up on the next successful refresh. The page refreshes automatically every 30 seconds while open, or you can select Refresh now. All rows are retained; matching projects are not merged.

Loading projects...

SourceCustomerProjectValueConfirmed?

Values use each source sheet's currency/units; no currency conversion is performed. Edit projects in the original spreadsheets.