Charts Plotting 0

Paul Newcome

@Josh Reed When copy/pasting, you have to ensure that your ranges and columns are named exactly as the formula you are pasting in. I copy/paste quite frequently, so I couldn't say for sure what issue you may have run into.

Josh Reed

@Paul Newcome Interesting, maybe I misplaced a comma or something instead. I literally copy/pasted the entire formula as I am creating a simple bar chart displaying count of contracts per month for a given category, and I'd like to display numbers, unless they are 0.

=IF(COUNTIFS({TA-Tracker}, "Immunology & Inflammation", {Event Date-Tracker}, >=DATE(2022, 4, 1), {Event Date-Tracker}, <=DATE(2022, 4, 30)) > 0, COUNTIFS({TA-Tracker}, "Immunology & Inflammation", {Event Date-Tracker}, >=DATE(2022, 4, 1), {Event Date-Tracker}, <=DATE(2022, 4, 30)), " ")

Nothing crazy, when I typed it out manually, no problem. I must have made an error or something on the first attempt.

Thanks again!

Sarita Sah

https://community.smartsheet.com/discussion/comment/349477#Comment_349477

Hi Paul, I really need help in adjusting my formula to not show Zero on dashboard graph. I want to show all data on graph and it has a lot of zero as well but I want only greater than zero to be displayed on the graph

My formula is =COUNTIFS({IAT Data Analysis Range 3}, $[Primary Column]$47, {IAT Data Analysis Range 1}, $[Primary Column]$48, {IAT Data Analysis Range 2}, [Column2]$48, {IAT Data Analysis Range 4}, $[Primary Column]49)

Paul Newcome

@Sarita Sah You would need to adjust your formula to say that IF it is greater than zero then output the result.

=IF(COUNTIFS(......)>0, COUNTIFS(.....))

Sarita Sah

https://community.smartsheet.com/discussion/comment/362188#Comment_362188

This is giving error UNPARSEABLE.

=COUNTIFS({IAT Data Analysis Range 3}, $[Primary Column]$11, {IAT Data Analysis Range 1}, $[Primary Column]$12, {IAT Data Analysis Range 4}, $[Primary Column]@row, {IAT Data Analysis Range 2}, [Column2]$12, {IAT Data Analysis Range 8}, <=$[Column2]$11),>0,COUNTIFS({IAT Data Analysis Range 3}, $[Primary Column]$11, {IAT Data Analysis Range 1}, $[Primary Column]$12, {IAT Data Analysis Range 4}, $[Primary Column]@row, {IAT Data Analysis Range 2}, [Column2]$12, {IAT Data Analysis Range 8}, <=$[Column2]$11)

Paul Newcome

@Sarita Sah You forgot the IF at the very beginning.