Create a Duplicate Flag


I am trying to create a flag that turns red when a duplicate name is entered. Here is the formula I have so far, but it keeps telling me it is "#Unparseable"

=IF(COUNTIF([Client/Resident Name]:[Client/Resident Name]@cell) > 1, 1)

Best Answer

  • Maria Watters
    Maria Watters ✭✭✭✭✭
    edited 04/30/20 Answer ✓

    Never Mind! I figured out what I was missing:

    This worked for me: =IF(COUNTIF([Client/Resident Name]:[Client/Resident Name], [Client/Resident Name]@row) > 1, 1, 0)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!