Fix Incorrect Argument Set when Matching Max Values

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!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!