How to find the Max Valor using INDEX and MATCH?
Options
Answers
-
@Jeff Reisman Hello Jeff, Could you please review the case, just to find a solution to this issue. Thanks in advance.
Regards
Rodolfo
-
I think you'd be better off using a MAX(COLLECT) here.
=MAX(COLLECT({tkpsRangeScore}, {tkpsRange}, Payroll@row))
In English: Collect the values from tkpsRangeScore where the tkpsRange is the same as the Payroll value from this row, and then return the highest number.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Hey Jeff thanks a lot for your help. I appreciate a lot your effort invested in this issue.
Regards
Rodolfo
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
