Search for Duplicate Names within Two Separate Sheets


Good Morning,

I am trying to enter a formula that will give a show me when a duplicate name is enter into one or the other sheet I am working on. We will be entering names daily into each sheet and we need to quick way to find if we have entered the same name in twice. Please let me know what formula you think will be best. I keep getting the errors unparseable and circular reference when I try to enter in the formulas.

Thank you,

Caroline Bush


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!