Checking for Duplicates in Parent Row ONLY

Options

Hi,

I am trying to build an equation/IF statement that Flags projects with duplicate project numbers. I only want the equation to apply to the Parent project number (because the children under the project have the same project number and would trigger the check box). This is what I was thinking but doesn't seem to work for my purposes.

=IF(AND(Parent@row=0,(COUNTIF([Unique ID]1:[Unique ID]1032,[Unique ID]@row)>1;1)


Any help you could provide would be much appreciated! Thank you in advance

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!