Formula to look for duplicates using multiple criteria


I currently have this formula which is looking for duplicates in APPID:


I would like to add another formula to this which will look first at the APPID to see if they are the same, and then look in the N column to see if the name is the same.

If the name is the same, then it should return "FLAG", if the name is not the same, it should not flag it all.

APPID = 1234, and N = ABC

APPID = 1234, and N = DEF

In this case, the formula should not flag this as a duplicate because the value of N is not the same. If the value of N had been ABC in the second occurrence, then FLAG should be returned.

I was wondering if someone could please help me figure this one out, thanks!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!