Previously, the consolidation was done in real time by exporting all data to a Google Spreadsheet. This is usefull to compute data, create dashboards, publish charts, etc…
But sometimes, it’s nice and efficient to have a quick view on consolidated data.
This is what does the new “Consolidation” button. You will see consolidation of your Entities (and only those that have been shared to you, see access rights
Reports for Work provides Advanced Forms to Collect, Consolidate and Report data with Google Sheets. It’s an easy and simple tool that provides fast added value to your business.