Link an Automated Column to Numerous Sheets

I have a master list that has multiple duplicates and I would like to de-duplicate this data and have it in another sheet. However, my master list is automated through a web forum so the information is updated automatically and I need it to translate to the other sheet if there is a new contact added.

How do I:

  1. De-duplicate a list that is constantly changing into another sheet?
  2. Get this running de-duplicated list into another spreadsheet that will count another criteria total?

Any help would be greatly appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!