Return the highest and 2nd highest value

J. Angel
J. Angel ✭✭
edited 08/18/22 in Formulas and Functions


I need a formula which will return the highest and 2nd highest value. For the table below, it would need to return "Wednesday" as the highest and "Tuesday" as #2.


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You are going to want to use the LARGE function inside of a nested IF statement.

    =IF(Saturday@row = LARGE(Saturday@row:Friday@row, 1), "Saturday", IF(Sunday@row = LARGE(Saturday@row:Friday@row, 1), "Sunday", IF(Monday@row = LARGE(Saturday@row:Friday@row, 1), "Monday", ....................

    To get the second highest you would change the 1 in the LARGE function to a 2.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!