Is countif working?

TracyLAshton

Hi everyone. No matter what column I use in my sheet I can’t get countif to work. Is anyone else having an issue?

Genevieve P.

Hiya!

Just jumping in here @TracyLAshton to say that I see your quotes are angled. ”

Smartsheet needs the straight quotes you'll see if you type directly in a cell: "

=COUNTIF([Project Progress]:[Project Progress], "In Progress - On Track")

Keep in mind that adding quotes turns a number to text, so you may see 0 if your column has numbers in it. For the "Number of units" you may want to just count the number instead:

=COUNTIF([Number of Units]99:[Number of Units]520, 22)

Cheers,
Genevieve

TracyLAshton

to clarify, I am getting #unparseable

rrenee

Hi Tracy, I have not heard of any issues at this time. Would you mind pasting your formula here so we can view it? #UNPARSEABLE is usually an indicator of a minor formating issue so I'm sure we can assist you in checking what might have caused the error. @TracyLAshton

TracyLAshton

=COUNTIF([Project Progress]:[Project Progress],”In Progress - On Track”‌

=COUNTIF([Number of Units]99:[Number of Units]520,”22”

Cathy Salscheider

Put a close paren at the end

=COUNTIF([Number of Units]99:[Number of Units]520,”22”)

Genevieve P.

Hiya!

Just jumping in here @TracyLAshton to say that I see your quotes are angled. ”

Smartsheet needs the straight quotes you'll see if you type directly in a cell: "

=COUNTIF([Project Progress]:[Project Progress], "In Progress - On Track")

Keep in mind that adding quotes turns a number to text, so you may see 0 if your column has numbers in it. For the "Number of units" you may want to just count the number instead:

=COUNTIF([Number of Units]99:[Number of Units]520, 22)

Cheers,
Genevieve

TracyLAshton

@Genevieve P. you are a genius. This solved my problems. I am not sure why my “ is slanted but I will deal with that from my end. Huge thank you