Help

Help with detecting duplicates in a field

Topic Labels: Formulas
Solved
Jump to Solution
1756 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Janene_Pappas
5 - Automation Enthusiast
5 - Automation Enthusiast

I’ve attempted to follow the recommendations here to detect duplicates in a field but have not been successful and could use some expert eyes on what I’ve implemented. I did put a reply on that thread but since it’s a couple of years old, figured I should start my own question. Here are 2 screenshots from the 2 tables in play. Anyone see where I went wrong? TIA!

Screen Shot 2022-03-28 at 12.40.20 PM
Screen Shot 2022-03-28 at 12.38.13 PM

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

values is a pure array, the formula you wrote needs to handle strings. So replace all instances of values with ARRAYJOIN(values)

See Solution in Thread

4 Replies 4
Kamille_Parks
16 - Uranus
16 - Uranus

values is a pure array, the formula you wrote needs to handle strings. So replace all instances of values with ARRAYJOIN(values)

Thanks for the reply @Kamille_Parks

I thought the field {All IDs} being an ARRAYJOIN already would then be put into the Number of IDs rollup as the long text result of the ARRAYJOIN?

You’re doing a rollup of a rollup. So you’re still dealing with an array of strings, even though every record is linked to just one record its still an array.

Thank you for the explanation and this worked great!