Forumla showing 0s  would like it to be blank if 0
Hello, I am trying to make my formula to be blank if a 0 shows up and I do not want a 0 showing up on my dashboard. I tried adding the if function and must of been entering it wrong because it did not come back as an actual formula.
The below is the current formula I am using. I am pulling data from a set of rows based on department name and if a goal is "In Progress" "Not Started" or "Complete"
=COUNTIFS({Department column}, $[Column3]@row, {Progress column}, [In Progress]$1)
Any assistance is appreciated. Thank you
Best Answer

@Steve1298 Try this...
=if(COUNTIFS({Department column}, $[Column3]@row, {Progress column}, [In Progress]$1)=0,"",COUNTIFS({Department column}, $[Column3]@row, {Progress column}, [In Progress]$1))
Basically if your formula result returns a 0, then blank, else execute your formula.
Answers

@Steve1298 Try this...
=if(COUNTIFS({Department column}, $[Column3]@row, {Progress column}, [In Progress]$1)=0,"",COUNTIFS({Department column}, $[Column3]@row, {Progress column}, [In Progress]$1))
Basically if your formula result returns a 0, then blank, else execute your formula.

@JamesB thank you! It works.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!