If outcome of Formula is 0 show blank

Hi All,

I'm using a formula to count how many stores we have opened in a certain country/month. This information is then used in a chart in a dashboard. The problem is that when we haven't opened any store it shows a zero. This zero is also displayed in the chart, and don't want this. So is it possible to make the formula work in way that when the outcome is zero show blank?


I'm using the below formula to count every store we have opened.

=COUNTIFS({Master Summary Roll Up - Boss Sheet Range 2}; "Netherlands"; {Master Summary Roll Up - Boss Sheet Range 3}; "New Location"; {Master Summary Roll Up - Boss Sheet Range 1}; 1; {Master Summary Roll Up - Boss Sheet Range 4}; AND(@cell >= DATE(2019; 7; 1); @cell <= DATE(2019; 7; 31)))


Thanks all!

Best Answers

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help! 👍️

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!