MODE Function
JeromeRod
โญโญ
Is there a function within smartsheets that mimics the MODE function in excel? Looking to find the most occurring text within a column.
Answers
-
Smartsheet (as of yet) does not have built in MODE functionality. You're not the first to ask this type of question.
Here is a workaround posed by others. Other than this sort of configuration, the use of a third party app would be needed.
https://community.smartsheet.com/discussion/42701/formula-to-retrieve-most-frequent-number
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!