Formula for Unique Values

swaldon2 ✭✭✭✭✭
edited 02/15/24 in Formulas and Functions

I need a formula that will check a check box column when a project name is not unique. The check box column is "Duplicate Portfolio Name" and the name column is "Portfolio Name".


Best Answer

  • heyjay
    heyjay ✭✭✭✭✭
    Answer ✓
    =IF(COUNTIF([Portfolio Name:Portfolio Name], [Portfolio Name]@row) > 1, 1, 0)

    1 = Checked, Not Unique

    0 = Unchecked, Unique

    If I got it backwards, please switch 1, 0



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!