Check for Duplicates and Blanks

Hayden Helms

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?

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))

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