Recently broken formulas If(CountIF to find duplicate values

nbers

For several months I have succesfully used the following formula to identify duplicates values in the Program ID column.

=IF(COUNTIF([Program ID]:[Program ID], [Program ID]@row) > 1, "Duplicate", "Unique")

Program ID is a formula generated column using the following formula.

=[Site Num]@row + "." + ProgNum@row

A recent Smartsheet update has broken this formula. As you can see, 22.01 should throw a duplicate value but it does not.

Victoria_Indimar

@nbers I'm not exactly sure why but it looks like your formula is just missing an "=" for your COUNTIF criteria. I bolded below. Please try this and see if that helps resolve!

=IF(COUNTIF([Program ID]:[Program ID], =[Program ID]@row) > 1, "Duplicate", "Unique")

Victoria_Indimar

@nbers I'm not exactly sure why but it looks like your formula is just missing an "=" for your COUNTIF criteria. I bolded below. Please try this and see if that helps resolve!

=IF(COUNTIF([Program ID]:[Program ID], =[Program ID]@row) > 1, "Duplicate", "Unique")

nbers

Thank you - that did indeed work. Do you know if this is recent change to formula writing in Smartsheet? Prior guidance from Smartsheet experts (like here) excludes the extra = sign and even the (albeit not very good) AI formula generator within smartsheet leaves out that extra = sign.