COUNTIF = "True" as string, not boolean

[STEVEMILLS04]

I run a report from our HR system that outputs a True/False column as a string (verified using =TYPE() formula). When attempting to do the countif formula below on the column it does not count them:

=COUNTIF(TermList[Is Voluntary?],"False")

It works when I change the column to a Boolean and change the formula to FALSE rather than "False" but this would not be my preferred method because I don't want to have to edit the column every time I run the report.

Any tips?

 

[Jonmo1]

Although, despite your desire to not have to manipulate data.
I still recommend converting those textual true/false to real Boolean.
You may likely have need for other formulas in the future to refer to them.
It's usually best to fix a problem at it's source, rather than work around it.

Maybe you can look at the report that puts those true false values there as strings in the first place, maybe that process can be adjusted

 

[Rick Rothstein]

Thanks Jack, I should have mentioned that my formula is actually a much longer IF/COUNTIFS formula:

=IF(Month>=C2,COUNTIFS(TermList[Location ID],$A2,TermList[Job Title],$D2,TermList[Term Month],MONTH($C2),TermList[Term Year],YEAR($C2),TermList[Is Voluntary?],"False"),0)

If you could have other values besides True/False (for example, Falsehood, False Vote, etc.), then try changing the "False" section to this...

TermList[Is Voluntary?],"Fals*",TermList[Is Voluntary?],"????e"

 

[JackDanIce]

@Jonmo1 Agreed!