Count if a cell has two values

AGorgei

I'm trying to count if a cell has the values of either 'Yes' or 'No' but am getting an 'Unparseable' error.

=COUNTIF([Description Format(correct format)]:[Description Format(correct format)],OR(@cell=“Yes”,@cell=“No”))

Help! Thanks in advance!

Paul Newcome

See how your quotes are slanted but "these" are not? Those slanted ones are called "smart quotes" which (ironically enough) are not recognized as valid characters in a Smartsheet formula. You will need to retype them directly in the sheet, here in the Community, or in a text editor such as Notepad (not Word).

Paul Newcome

See how your quotes are slanted but "these" are not? Those slanted ones are called "smart quotes" which (ironically enough) are not recognized as valid characters in a Smartsheet formula. You will need to retype them directly in the sheet, here in the Community, or in a text editor such as Notepad (not Word).

AGorgei

Thank you @Paul Newcome ! I never would have figured that one out!! Darn quotes! :-)

Paul Newcome

Happy to help. 👍️