I am trying to display how many times "Approved" is in a column in my list. I can get the countif function to work when the field it is counting is just a plain number or text, but for some reason when the field is of type "choice" it gives me errors. Here is an example:
working fuction on a column of type "text": Countif('Policy Exceptions', comments = "this is a comment")
not working because the column type is "choice": Countif('Policy Exceptions', Approval_Status = "Approved") this gives me a red underline on the '=' character.
Does anyone have any info on what you have to do to count fields of a choice column? i just want to count the amount of exceptions that have been set to "Approved"
Thanks for your help!
