Hi all, I have an existing saved search for a custom record that is currently being summarized. I would like to know if there is a formula I can use to determine if any results share an arbitrary field text value. Essentially, I want a way to quickly find any duplicate hash values in this text field. Any thoughts on this?

Do a count based on that value/field and then set summary criteria to greater than or equal to 2?

From what I can tell, NetSuite doesn't allow summaries for Long Text fields, so I am using a Formula field. I'm a bit confused why the two duplicate hash values are only showing a 'hash count' value of 1. Perhaps I'm doing something incorrect here?

ah yeah, you want to count something that's unique amongst the records, like internal ID or something I think, since for those duplicates they both have the same hash value