Criteria is Parsable when using a number but unparsable when using text

Billymacdo

UNPARSABLE:
=COUNTIF({Brand To-Dos Range Status}, “Complete”)

Parsable:
=COUNTIF({Brand To-Dos Range Status}, 3)

Can’t tell if this is a bug or not

Paul Newcome

See how your quotes around "Complete" are slanted but the ones in this comment are straight up and down? The slanted ones are called "Smart Quotes" which (ironically enough) are not recognized as valid characters in a Smartsheet formula.

Try retyping the quotes directly in the sheet or in a text editor such as Notepad (not Word).

James Keuning

Both of those formulas resolve for me. So maybe a bug. Try a new sheet.

Billymacdo

Started from scratch and same result

PCG Sam Harwart

Hi @Billymacdo

Can you share a screenshot of the sheet & the range of the reference data in {Brand To-Dos Range Status}?

Paul Newcome

See how your quotes around "Complete" are slanted but the ones in this comment are straight up and down? The slanted ones are called "Smart Quotes" which (ironically enough) are not recognized as valid characters in a Smartsheet formula.

Try retyping the quotes directly in the sheet or in a text editor such as Notepad (not Word).