Formulas to identify duplicates

Chevon Brownell
edited 04/16/21 in Formulas and Functions

My company is assigning decals to vehicles to monitor our guests. Is there a formula to identify if a license plate has already received a decal if I am looking at my sheet? We will have 2000+ license plates and need this to be a quick glance, or automated notification. I know I am asking a lot so any help is appreciated.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!