Help creating a nesteed IF statement

Geoff Baker

Hi, I am looking to augment this statement:

=IF([TAG ID]@row = "", 0, IF(COUNTIF([TAG ID]:[TAG ID], [TAG ID]@row) > 1, 1))

I would like to have to also have it provide the same IF for [SUBMITTAL NAME] nested together

In short, it will check the [TAG ID] and [SUBMITTAL NAME] for duplicates and if either has duplicates then report a 1 or checkbox :)

Any help would be greatly appreciated.

Thanks in advance.

Geoff Baker

Andrée that worked perfectly :)

Thank you!

Kelly Moore

Hey @Geoff Baker

=IF([TAG ID]@row = "", 0, IF(OR(COUNTIF([TAG ID]:[TAG ID], [TAG ID]@row) > 1,COUNTIF([Submittal Name]:[Submittal Name], [Submittal Name]@row) > 1), 1))

Does this work for you?

Kelly

Geoff Baker

It is doing exactly as it is meant to do but it highlights another issue.

I have some cases where the SUBMITTAL NAME is BLANK, in those cases, it is triggering the DUPLICATION.

How do I exclude BLANK results from the formula?

Thanks so much for your help on this.

Andrée Starå

Hi @Geoff Baker

I hope you're well and safe!

To add to Kelly's excellent advice/answer.

Try something like this.

=
IF(OR([SUBMITTAL NAME]@row = "", [TAG ID]@row = ""), 0, 
IF(OR(COUNTIF([TAG ID]:[TAG ID], [TAG ID]@row) > 1, 
COUNTIF([SUBMITTAL NAME]:[SUBMITTAL NAME], [SUBMITTAL NAME]@row) > 1), 1))

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Geoff Baker

Andrée that worked perfectly :)

Thank you!

Andrée Starå

@Geoff Baker

Excellent!

You're more than welcome!

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!