Conditional Formatting for Dashboard Metric Widgets

GMichal

When using dashboard metric widgets, it would be helpful to be able to have conditional formatting features to compare performance to a KPI or otherwise enhance the metric display. Even if the data source document already has the conditional formatting existing, it will not transfer along with the data to the dashboard widget which could be an easy solution.

Paul Newcome

I do this all the time. Just use the format painter on the data formatting within the metrics widget. This will pull through the formatting of the cell being referenced by that widget to include conditional formatting rules within the source sheet.

GMichal

Paul, thank you so much. When I couldn't figure out how to do conditional formatting on a widget, I contacted Smartsheet support who told me that this feature was not available and I should submit the suggestion for future implementation. It works perfectly!

Paul Newcome

Support was probably thinking about applying conditional formatting to the widget itself which is not possible.