Return most occurring value in multi-select column


I'm trying to count the most occurring value (text not number) in a multi-select column, then return that value. Is there a way to count distinct values, rank then return the value with the highest rank in one formula without setting up a separate helper column or metric sheet?

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!