Highlighting duplicate values in a column


I created a helper column with this formula =COUNTIFS([Supplier Lot #:]:[Supplier Lot #:], [Supplier Lot #:]@row) so I can set a conditional format to highlight duplicate values in this lot supplier lot column. However, I noticed that duplicate values are not highlighted if the values have zeros in front of them. Can someone help me with a work around?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!