Populate Text Based on Max Value

Options

Hello,


I need a formula that will return the name of the vendor with the most votes for each user.


Thank you!


Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Mallory McFall ,

    I can't see your column names or row numbers so you'll need to adjust but try:

    =JOIN(COLLECT(Vendor1:Vendor4, [John Smith]1:[John Smith]1, MAX([John Smith]1:[John Smith]4)),"-")

    This assumes the column with you vendors is [Vendor] and Vendor 1 is in Row 1; Vendor 4 in Row 4. And, that the users name is the column name for them.

    If more than 1 vendor has the most votes it will return them all with a"-" between the names.

    Help at all?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Mallory McFall ,

    I can't see your column names or row numbers so you'll need to adjust but try:

    =JOIN(COLLECT(Vendor1:Vendor4, [John Smith]1:[John Smith]1, MAX([John Smith]1:[John Smith]4)),"-")

    This assumes the column with you vendors is [Vendor] and Vendor 1 is in Row 1; Vendor 4 in Row 4. And, that the users name is the column name for them.

    If more than 1 vendor has the most votes it will return them all with a"-" between the names.

    Help at all?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Mallory McFall
    Mallory McFall ✭✭✭✭
    Options

    All of your assumptions were correct! I modified the view for privacy purposes. Thank you so much for your help!

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Options

    Happy to help. Thanks for using the Community.

    Be Well,

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!