Distinct Function and creating a helper column


Well, I am striking out. I want to create a helper column generated off the Distinct Formula. Basically, i want to place a 1 in a column if the [Base] Column is distinct to other entries.

=IF(DISTINCT(Base:Base), 1, 0) is my formula thought but i dont know exactly how to accomplish this.

Thanks for your help in advance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!