We have a work around but it takes multiple helper columns and complex formulas.
You need WBS numbering
Per the 1.5 years of queries being made, I believe there is suitable interest from the Community that Smartsheet provides the basic functionality of being able to print a Grouped Report. The system currently reverts the Report to a basic Sheet when Print is selected. This is not suitable or acceptable.
We've stopped developing our Smartsheet documents due to this restriction and now sit in a holding pattern waiting for an update. - See Printing Grouped Reports - Page 3 — Smartsheet Community.
Today, when adding the reports widget to the dashboard upon clicking for the source report user is presented with the dialog with all the reports across the Workspaces and this list is expanded by default making it difficult to scroll and look up (yes there is search but when you have reports with same name across folders and workspaces it is not very helpful).
Alternatively, user can be presented with the reports in the current workspace to start with.
The Contact List, Dropdown (Single Select), and Dropdown (Multi Select), are useful tools to control data entry. The problem is they require a lot of maintenance.
Through Bridges, we have a sheet that is populated with information from our ADP. It contains all of our employees. Using a Contact List column and selecting the range of emails on the Employee sheet, as values would be very useful.
Moving to the dropdown column, it would be helpful if we could set some defined values, but if a new value is entered, have that value added into "values" for that dropdown column.