Column Formulas for Duplicates

Identifying duplicates with consideration of blanks


This is the formula I am using to identify duplicates and trying to omit blanks and it is giving me a syntax error, can someone please help?


Also, could I make this a column formula?


=IF(ISBLANK([Folder Name]),"", IF(COUNTIF([Folder Name]:[Folder Name], [Folder Name]@row) > 1, 1, 0)



Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    edited 05/18/21 Answer ✓

    Hi @Katrina Liu

    It looks like you forgot an '@row' at the beginning of your formula. This should allow you to convert to a column formula.

    =IF(ISBLANK([Folder Name]@row),"", IF(COUNTIF([Folder Name]:[Folder Name], [Folder Name]@row) > 1, 1, 0))

    cheers

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    edited 05/18/21 Answer ✓

    Hi @Katrina Liu

    It looks like you forgot an '@row' at the beginning of your formula. This should allow you to convert to a column formula.

    =IF(ISBLANK([Folder Name]@row),"", IF(COUNTIF([Folder Name]:[Folder Name], [Folder Name]@row) > 1, 1, 0))

    cheers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!