Best Of

Hi @Lynn U, @kowal and @celtics345,

I'm jumping in here as I've tested this and it's working on my end. This is also discussed in this related thread: Adding a dashboard link to a different dashboard, where @cg80 has suggested the feature is now working again. It therefore looks like this may have been a temporary issue which is now resolved.

Could you all take a look again and see if you're still experiencing the issue? If you are, I'd recommend submitting a support ticket so the team can investigate.

Thanks!

Georgie

I would LOVE to help with the previewing, thank you so much, both of you!!!

It seems selecting a dashboard as a shortcut widget is an option again.

Hi @Rebecca BdR

Suppose your sheet is like the one below, except for the City column.

https://app.smartsheet.com/b/publish?EQBCT=cbd92ee440124fe39d79b3329f537c75

To create a summary by city and status, we need a city value corresponding to the status value.

So, we add a helper column, City, and get the Parent or Grand Parent data in the Task Name column, using the following formula.

[City] =IF(ISTEXT(Status@row), INDEX(ANCESTORS([Task Name]@row), 1))

The IF pat is to show the city value if the Status is not blank, so NOT(ISBLANK(Status@row)) is also acceptable.

The ANCESTORS function gets all the parents' or ancestors' values as a range, and by specifying to get the top one by the INDEX function, we can get the city value, if that is the top of the hierarchy.

If you already have the City column and corresponding values, you can omit the formula part.

From this sheet, you can create a master report that includes all cities.

Then, from the report's Fike menu, you can use the "Save as New" menu to create copy of the report for each city.

In the newly copied or created report, change the filter to select only one city, Tulsa, for example.

You can use this report to show charts or a report in a dashboard.

In the dashboard below, I first created a semi-circle pie chart, copied the chart, and changed it to a bar chart.

https://app.smartsheet.com/b/publish?EQBCT=a1714a19e6f34e459603960ce6ce08a8

You can repeat the same process for other cities.

Though not completely "formula-free way", I guess this method lets you create a dashboard with a minimum formula.

Hi @Rebecca BdR and @jmyzk_cloudsmart_jp, I am the Product Manager at Smartsheet for Charts and Metric Widgets and I just wanted to chime in here.

Metric widgets currently do not support data from Reports. Once you have the helper column, you will need to create a separate sheet that houses the calculations (COUNTIF) for each city and status. Then use that sheet as the data source for your metric widget.

Today's process for creating charts and metrics is heavily reliant on our customers knowing how to use formulas, and we understand that it is unintuitive and cumbersome. We are working on a new creation experience that enables the user to select the aggregations (sum, count, avg etc) they want from a dropdown and not have to write out formulas. This experience will begin with charts, and then extend to metric widgets in the future. If either of you are interested previewing these new concepts and giving us your feedback, I would love to set up a call with you. It would greatly help us shape the solution. Let me know, and thank you either way!

-Rashmi