Complicated COUNTIF Formula
I finally got my formula right to count based on certain criteria but now I'm trying to figure out how to get it to enter a blank instead of a zero:
=IF(COUNTIF({Status Range 6}, [Column 6]@row = 0), "", COUNTIFS({Status Range 6}, [Column 6]@row, {Status Range 3}, @cell <> "New Configuration"))
What I'm trying to do specifically is this:
 If the value in Column 6 does NOT occur in "Status Range 6", enter a blank
 If the value in Column 6 does occur in "Status Range 6" but the value on that row in "Status Range 3" is "New Configuration", then enter a blank
 If the value in Column 6 does occur in "Status Range 6" and the number of times the value in Column 6 occurs in "Status Range 6" AND the value on that row in "Status Range 3" is NOT "New Configuration", then count the number of times it occurs.
The formula that I wrote above seems to work except I'm getting zeros instead of blanks...
Best Answer

Try moving the closing parenthesis after zero to before the =.
Answers

Try moving the closing parenthesis after zero to before the =.

Wow! That worked. But how?! :)
Thanks so much!

Ah. Never mind. I see. Rookie mistake...which is ok because I'm a rookie. Thanks again!!!

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 454 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!