How to Remove Duplicate Site Names??

Hey Smartsheet Community,

I am trying to remove duplicated Site Names from my sheet and am running into some issues. Can someone please help me come up with a formula to accurately remove all duplicated site names? (Backstory: I copied a lot of data over and some of it is duplicated so we are trying to remove the duplicates).

Below is a screenshot of the site name column and the duplicate column I have next to it.

Please let me know if you have any questions, I am hoping this is easier than I am thinking.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!