Check for Duplicates and Blanks

I want to check a column for duplicate entries, but if the field is blank, I want it to be ignored. So far, here's what I have. It works for checking duplicates, but if it's blank it still sets it's value to 1 (because there are multiple blank rows). I'm using this for an automation script in a column formula to have all rows flagged send an email.

=IF(COUNTIF([Actual Funding Source]:[Actual Funding Source], [Actual Funding Source]@row) > 1, 1, 0)

What can I add to this statement to get it to only count the rows with data input in them?

Find more posts tagged with

Formulas

Accepted answers

Hayden Helms

Figured it out. Had to do a blank check first.

=IF(ISBLANK([Actual Funding Source]@row), 0, IF(COUNTIF([Actual Funding Source]:[Actual Funding Source], [Actual Funding Source]@row) > 1, 1))

All comments

Hayden Helms

Figured it out. Had to do a blank check first.

=IF(ISBLANK([Actual Funding Source]@row), 0, IF(COUNTIF([Actual Funding Source]:[Actual Funding Source], [Actual Funding Source]@row) > 1, 1))

Andrée Starå

Hi @Hayden Helms

I hope you're well and safe!

Excellent!

Glad you got it working!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

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.