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
Check out the Formula Handbook template!