Formula for Unique Values

swaldon2 ✭✭✭✭✭

02/14/24 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".

Tags:

• Formulas

0 · Share on FacebookShare on Twitter

Best Answer

• 

  heyjay ✭✭✭✭✭

  02/14/24 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

  ...

  0 · Share on FacebookShare on Twitter

Answers

• 

  heyjay ✭✭✭✭✭

  02/14/24 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

  ...

  0 · Share on FacebookShare on Twitter
• 

  swaldon2 ✭✭✭✭✭

  02/14/24

  @heyjay That worked, thank you!

  1 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list