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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!