Dynamic "UNIQUE" Function

Is there any type of function similar to the UNIQUE function in Excel that I can use? I have a Master List on one Sheet (called "QMS Transformations Common List") and I want to use links for the first column on another sheet ("named "QMS Metrics Calculation - Workstreams"). In excel I could use the UNIQUE function, and it would also make sure there are no duplicates. But mainly it would allow me to use a link, which means I only need to update the data in one location.

Sherry Fox

Project Analyst | Core Quality Services (QMS Transformation)





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!