Simple COUNTIF Formula Suddenly Stopped Working?!

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

Find more posts tagged with

Formulas

Accepted answers

Cheryl Collins

Now resolved

All comments

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?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.