Help with Formula for Unique IDs

rmalenda
rmalenda ✭✭
edited 12/09/19 in Formulas and Functions

Hello, I'm working on dashboard that will track a list of vendors.  Some vendors have multiple locations, so the vendor name would appear the same from row to row with other fields unique to location, while other vendors only appear once because they only have one location.  Those who have multiple locations only need to count once even though the vendor name could appear multiple times.  I'm looking for a formula that would allow me to only count unique entries from this column.  Could anyone help with this?  Thank you!

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!