Dynamic Filter on Dashboards

I'd LOVE to easily be able to filter across all the selected and appropriate Widgets on a Dashboard. I hope that will be an option one day.

The work around I've created is bulky and required about a 60 second refresh to work. Its not ideal.

I am excited to see that this is on the roadmap finally! Smartsheet does have a template in the template gallery that does exactly what you are suggesting. I was glad to see that template after last year's Engage. But to have a much better way to slice and multi slice would be huge!!!

I too expect a slicers options in smartsheet

Hi all, I thought I would add to this discussion to share how I solved this for myself. Like most of us I was battling to be able have one report and open it with filtered data selected via a dashboard instead of having loads of reports for each combination of selections. I have managed with some limitations (being that the filtering criteria is limited to single drop down lists) to achieve filtering from the dashboard.

I will provide a quick summary here, feel free to contact me for detail if you think this can help you.

1. Add a column to your master data sheet that your report draws its data from, for me this column is a text/number column called something like, "included from filter". This will be the column added to your report set up to filter on.
2. Create 2 helper tables, one (I called Dynamic Filter) containing all the columns with their drop downs you want to choose to filter your master data with. I include an "All" selection in the drop down as well. Then create a form with all these fields and select a default, mine is the "All" option. Now add automation to move the previous row out whenever a new row is added, I move this to the second helper table called Dynamic Filter Old. The automation means that only one row should ever be in your Dynamic Filter sheet.
3. Add the new form from the Dynamic Filter sheet to your dashboard to allow for filtered selection.
4. In your master data sheet in your new field called "included from filter" you need to add a formula that looks up and compares the selection data in the column in that row to the selected data in the same field in the single row added to the Dynamic Filter table from the form on the dashboard. I allocate a "1" if it is to be included and "0" if it is not. I also have an "All" which is an autonomic "1" without the need for comparison. For a row to be included in the report all the selections need to be "1", a returned "0" would mean not to include it. I achieve this through a logic multiplication as 1 x1 is 1 and 1 x 0 is always a zero. This means in the report I just filter for 1 in this column. An example of my formula based on 5 selections including a value ("Spend") looks like this:

=IF((COUNTIFS({Dynamic Filter Range 1}, "All") = 1), 1, COUNTIFS({Dynamic Filter Range 1}, [Brand]@row)) * IF((COUNTIFS({Dynamic Filter Range 2}, "All") = 1), 1, COUNTIFS({Dynamic Filter Range 2}, [Sector]@row)) * IF((COUNTIFS({Dynamic Filter Range 3}, "All") = 1), 1, COUNTIFS({Dynamic Filter Range 3}, [Project Type]@row)) * IF((COUNTIFS({Dynamic Filter Range 4}, "All") = 1), 1, COUNTIFS({Dynamic Filter Range 4}, [Sub Project Type]@row)) * IF((COUNTIFS({Dynamic Filter Range 5}, "All") = 1), 1, COUNTIFS({Dynamic Filter Range 5}, <[Spend]@row))

As there is only 1 row in the Dynamic Filter sheet the returned COUNTIFS value will always be 1 if true.

5. Create your report based on your master data sheet with the filter selecting all rows to be included, i.e. >0 or 1 in the new "included in filter" column.

Hope this brief summary is coherent and helps someone!

Thanks