Need Help with IF Statement with Countif

Hi Smartsheet community. I have been working on a formula and it has not been working. Wondering if I am going about it the wrong way?

I am working on a lessons learned project sheet where i am confirming if a root cause issue is being repeated or if it is new. This information is in the same sheet.

My formula is below. The column I am referencing is in the same sheet as the formula and I am getting a #invalid ref error.

=IF(COUNTIF({Root Cause / Observation - Issue}, [Root Cause / Observation - Issue]@row > 1), "Repeat", "New")

Any help would be greatly appreciated!

Find more posts tagged with

Countif

IF(

Accepted answers

All comments

Michelle Choate 2

Well the error seems to say there is something wrong with your reference from the other sheet. Can you double check to make sure you did not just click one cell instead of a whole column?

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.