Formula not working

Hello,

I have a formula that is working in one sheet but is in another.

What I am trying to achieve is to add a 1 into a column when a number is featured in another column only once so I can pull that into a report.

I am trying to pull a status report of contracts but the contracts are listed multiple times.

=IF(COUNTIF([Contract No #]$1:[Contract No #]$11254, [Contract No #]@row) <> 1, 0, 1)

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hi @Faye Sumner

The range in your formula has a row start (row 1) and a row end (row 11254). If your first sheet doesn't have 11254 rows, then you'll receive an error, since it can't look that far down.

=IF(COUNTIF([Contract No #]$1:[Contract No #]$11254, < here

Can I ask why there are specific rows identified in your range? It looks like you just want to evaluate the whole column, is that correct? If so, you don't need any row reference at all!

Try this:

=IF(COUNTIF([Contract No #]:[Contract No #], [Contract No #]@row) <> 1, 0, 1)

Cheers,

Genevieve

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.