Identify Duplicate Values in a field


#1

I’m looking to write a formula that notifies me if there are duplicates of a certain field. There are other unique values in the spreadsheet, so I’m not looking to merge or delete them, but I want to be notified if a certain cell is not unique. I do this in Excel with:

=COUNTIF($B$2:$B2, B2)>1

Is there any manner to do this in AirTable? From what I’m seeing, lookup and rollup options that have been suggested in the community require an additional table and I’m looking to do this from the same table.

Thanks