Fix Incorrect Argument Set when Matching Max Values

Options

Hi! I'm trying to return a number value from my "Score" column in my sheet summary. The Score I want is whichever one has the latest date in the "Score Date" column. To accomplish this I'm trying to use the following formula:

=INDEX(Score:Score, MATCH(MAX([Score Date]:[Score Date])))

I'm getting an incorrect argument set error and I'm hoping someone can spot where I went wrong because I'm fairly new to formulas and am not sure where my mistake is.


Thank you!

Tags:

Best Answer

  • Alex Folck
    Alex Folck ✭✭
    Answer ✓
    Options

    Figured it out, I needed to specify a range for the MATCH. Correct formula was:

    =INDEX(Score:Score, MATCH(MAX([Score Date]:[Score Date]), [Score Date]:[Score Date]))

    Woohoo!

Answers

  • Alex Folck
    Alex Folck ✭✭
    Answer ✓
    Options

    Figured it out, I needed to specify a range for the MATCH. Correct formula was:

    =INDEX(Score:Score, MATCH(MAX([Score Date]:[Score Date]), [Score Date]:[Score Date]))

    Woohoo!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!