Looking for a formula

Angela Campbell

=IF(AND([Email: I do not want vaccine]@row <> "", COUNTIFS([Email: I do not want vaccine]:[Email: I do not want vaccine], [Email: I do not want vaccine]@row) > 1), "Duplicate")

The email is not always mandatory which is why I need to be able to leave blank cells alone and if there is a true duplicate I need to be able to see the original (or one of) the submissions to be able to not only count number of submissions but as well as use automation to move duplicates to an archive sheet and not count as a true number for dashboard calculations.

Bassam Khalil

Hi @Angela Campbell 

Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

Andrée Starå

Hi @Angela Campbell

I hope you're well and safe!

What isn't working? As far as I can see, it should work.

I hope that helps!

Be safe and have a fantastic week!

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!

Angela Campbell

@Andrée Starå

The formula itself is working. The issue is that it is calling out all duplicates. I am looking for something that would leave the first submission alone and only call out all subsequent duplicates.

Angela Campbell

@Bassam Khalil

https://publish.smartsheet.com/83baf3db70884009962686993b8ab3ff

The duplicate is calling out both lines instead of leaving the original submission alone.