Having trouble with the duplicate formula and where to input.


I am trying to set-up a formula, so if there is a duplicate in the Family ID column, the box becomes checked in the Duplicate column. So far, during the searching I have done for other users with this same problem, I am still left with an error message each time.

Is there a way to run the formula on the whole column, or do I need to do it for each entry?

I would appreciate any help. Thank you in advance. 😊

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!