We work with dozens of spreadsheets. When will the dashboard allow us to see a snapshot of all upcoming deadlines? Clicking on every spreadsheet is causing usage in the office to significantly decline.
I dont have any details about what the new dashboard might include or when it would be available but I can offer a suggestion to help with your problem!
Reports enable you to pull in data from multiple sheets based on criteria you specific. You can build a report that shows you all tasks across all your projects/sheets that are due in the next X days. Reports are live updating and any changes made in a report are immediately reflected in the underlining sheet. You can also view a Gantt chart and calendar view of your data from within the report.
Here is information on creating reports: http://help.smartsheet.com/customer/portal/articles/522214-creating-reports