COUNTIF not working when trying to count with a % in the dropdown options.
I ran into an issue where I am looking for a work around to make the system count a column that has % options in the drop down. So it is a column with these as drop down options. 0%, 3%, 4%, 5%, and 7%. I have tried the normal =COUNTIF(Percentage:Percentage, ="0%") making one for each option, but it always returns as 0. I figured out that the system just doesn't like the 0% because if I change it to 0% putting a dash between 0 and the % it will then count them. I know in most coding % is a function used for things so my guess is that is the issue.
I tried the same thing in a summary field and it did this, in the picture below. Almost like it is making a secondary calculation or formula. That is with this line in there that it is doing this. =COUNTIF(Percentage:Percentage, ="0%").
I appreciate any thoughts or ideas on this one. Right now I am just having the team come up with something different for the 0% dropdown options. Something like 0/Percent, 3/Percent, etc. But they are not really loving that lol.
Best Answer

=COUNTIF(Percentage:Percentage, =0)
=COUNTIF(Percentage:Percentage, =0.03)
etc.
Answers

=COUNTIF(Percentage:Percentage, =0)
=COUNTIF(Percentage:Percentage, =0.03)
etc.

I don't know why I didn't even think to try that. Thank you, such a simple fix…. You Rock thanks again!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.1K Get Help
 381 Global Discussions
 212 Industry Talk
 444 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 450 Show & Tell
 30 Member Spotlight
 1 SmartStories
 291 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!