All of my percentage values in my dashboards are now decimals, How can I fix this?

Merit Sowards

Hello

With the recent update to the dashboards all of my percentages have turned to decimals. How can I fix this? I need help.

Thank you

Merit Sowards

meagans

Merit,

Hello! When you say percentages, are these within Report widgets on dashboards? Or are they Metric widgets? When you go to the underlying Sheet that houses this information, are they displayed in decimals as well? If so, you may need to change the data type within the Sheet to have it reflect again.

I hope this helps!

Merit Sowards

Hello Meagan

Thank you for the reply:)

The widget that I am referring to is the Chart Widget. I have verified that my underlying sheet does have the data currently set to be a percentage. When I hoover over the bar graph the pop-up no longer shows the percentage is shows the decimal. Is there a way to correct/update the graphs?

Merit

meagans

Merit,

Apologies for the delayed response - when you say Chart widget, what kind of chart (bar, pie, line)? Would changing the chart type help? Is it possible to post a screenshot or two to understand what you're looking at?

Merit Sowards

Hello Meagan

I have attached the image. I have tried changing the image and it did not change the information. Typically, there are a lot of bars and so I have refrained from displaying the data since prior we were not able to adjust the font size. Thank you for any assistance. :)

Jbronson

So, we are having a similar issue. It sounds like Smartsheet implemented a silent update to Dashboards, but as part of the update, the behavior of some of the widgets changed.

We have a Project Management workspace template, that includes a Project Sheet that calculates the number of tasks Not Started, In Progress, Completed, etc. Those numbers (integers) are fed into a Report. The Report then feeds into the Dashboard. We use a Donut Chart type in our example, where we format the values within the widget editor as a Percentage:

The "Value Label" of Percentage (%) seems to be forcing the additional decimal spaces. We have so many project dashboards with this set up, it would take many hours to manually change the source sheets to reflect as a decimal rounded to 0 decimal spaces.

Merit Sowards

JBronson -

Thank you for the reply, but none of my graphs are pie charts, the percentage is not available option for the bar graphs. I wish it was.