Return highest value

Becky Wilson
Becky Wilson ✭✭✭✭✭
edited 09/24/21 in Formulas and Functions

I need to be able to create a formula that will return the highest value based:


I want it to match the Auction Item and return the highest value in the Bid column and the name of the highest bidder

In this instance, I want the result to be

Concealed Carry class - $100 - Becky Wilson

Lydia Gillis Photography - $500 - Becky Wilson

Tags:

Answers

  • jodyh
    jodyh ✭✭✭

    Hi Becky,

    I was able to do this using two additional columns- one for the math to determine the highest bid (MAX, COLLECT) and then one to list the Winner Name

    For Highest Bid-

    =MAX(COLLECT(Bid:Bid, [Auction Item]:[Auction Item], [Auction Item]@row))

    For Winner Name-

    =IF([Highest Bid]@row = Bid@row, Name@row, "")

    Then convert to column formulas for both (and you can hide the Highest Bid column, since it's redundant).

    Cheers!

  • Becky Wilson
    Becky Wilson ✭✭✭✭✭

    Thanks. Is there a way to use the Max(Collect) in the Sheet Summary? I keep getting an Unparseable error when I try

  • I too would love to know the formula to get the Winner Name in Sheet Summary.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!