Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Determining top 3 items
Options
In creating a safety sheet for my company, I am trying to determine the top 3 subcontractors with the highest number of infractions. Is there a formula that can determine the top 3, when the sheet has a format like the following:
Sub x - 4
Sub y - 3
Sub z - 9
Sub w - 6
Sub v - 11
Sub t - 1
Sub u - 5
Any help would be appreciated!
Comments
-
This is an interesting problem that I currently don't have the time to finish, but I can get you started.
=RIGHT([Primary Column]5, LEN([Primary Column]5) - 8)
Will grab the number out of the chain.
https://exceljet.net/formula/match-next-highest-value
I believe will function in smartsheet as well.
This discussion has been closed.