Formulas won’t work for this because they’re not robust enough. A script could do it, but it would need to be designed to know what exactly constitutes a duplicate. The other question is this: once you’ve detected duplicates, what do you want to do with them?
It seems that the model is rolling up some data from another table, so one manual option is to use the “Dedupe” app on the other table to find and merge the records (if that is what you need to do).
As @Justin_Barrett mentions, the formulas may not be robust enough, although not sure if possible with regex.
Best
Sergio https://devblocks.agency If this reply fixed your problem, please mark it as a solution :white_check_mark:
