Simple COUNTIF Formula Suddenly Stopped Working?!

Cheryl Collins

Hi

I have had a very simple countif formula, that has been working with no problems for months, suddenly start retuning a #INVALIDOPERATION error.

I have reviewed the formula and can't see anything wrong with it, has anyone else had the same issue? Have Smartsheet released something and broken this?

TIA

Cheryl Collins

Now resolved

Cheryl Collins

Now resolved

Genevieve P.

Hi @Cheryl Collins

I'm glad you were able to resolve this!

For anyone else experiencing a similar issue, I can see that the referenced column had a column formula in it. Was the issue that a cell in this referenced column had the error, so the summary formula produced the same error?