Charts plotting 0
Hi all,
I am trying to come up with a formula to avoid showing 0 on a chart for a dashboard. I am using this formula but I am getting an incorrect argument
=IF(COUNTIFS({GIH Globalization Project Tracker Range 9}, "Product") > 0, COUNTIFS({GIH Globalization Project Tracker Range 6}, "Approved", {GIH Globalization Project Tracker Range 5}, "Q1 FY21"))
Basically I am trying to see how many products were approved in Q1 and if the number if 0, for that cell to show up as blank.
HELP!
Answers
-
Hope you are fine, could you please supply a screenshot ( remove any sensitive data ) to help me to write the exact formula for you
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hello Bassam,
Thank you for reaching out. Below is how my source sheet is set up. The information is being fed from a separate project tracker
I am basically trying to set up a dashboard of approved products for the fiscal year without the zero's showing up on a chart. Thank you in advance.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives