Using Collect with the large function


I have 3 columns in the same sheet:

The formula that is in the Case Total/Supervisor is (this works perfectly):

=LARGE([Total Issues]61:[Total Issues]150, 1)

I am trying to do the following:

  • I want to collect the name in the row with the Largest value. These are higher up on the sheet.
  • Put that name into the Name column.

The formula I am trying to use is:

=INDEX(COLLECT(Name61:Name131, LARGE([Total Issues]61:[Total Issues]131, 1))

Ultimately, I am trying to highlight the top 10 offenders but want it to be dynamic.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!