Alert when a duplicate entry is made


I'm trying to set up an automation that alerts when a duplicate entry is made. I am not having any luck utilizing the =IF[Countif] formulas and I'm looking for some assistance. In my sheet I am looking to flag duplicat Bin#'s in column 1.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!