I have a range of $$ amounts (to graph). One of the points is $0.00M; however, the Graph will not "graph" that point, why? is there a way around it?
I am using a report to Graph is onto a Dashboard (see below)
In that case, you can add 0.00001 to the end of the formula you are using to bring the number over. Use the button to decrease the visible decimals to none visible so it still shows as plain zero, and then it should be charted for you.
=[Sheet Summary Field]# + 0.00001
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
It is because the total is zero. How exactly are those numbers being populated?
In your example dataset there is 0 in the $0.00M column. 0% on a pie chart will not be displayed as there is nothing to display. If you used a bar chart there would be a gap for the column with 0 in. Would that help?
I need to use a PIE chart and want that point to be displayed as 0%. Is that an option?
@Paul Newcome the numbers, from the report (shown above) are coming from a Sheet Summary; through a formula; I am just pulling them into a report, so I can graph them.
this worked PERFECTLY! Thank you, @Paul Newcome
It does look a little "wonky" because it can't visually graph a 0%
Happy to help. 👍️
Hello - is it possible to use a group already established in SmartSheet to fill/populate a drop list for a data point? Example - we have a SS group created for 40 project managers, I would like to type the name of the group in the drop down and the 40 names populate in the drop down list without having to type all 40 names…
Hi, Is there a way to notify users on a specific month rather than every month? Thanks!
Hello Smarties! I need your help and ideas. I am trying to do some automations if a specific row is not checked after a specific date. I don't want it to interrogate the entire column, even if I need to create a new column, is there a way to do this?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.