Index If?

edited 12/09/19 in Formulas and Functions

Hi. I'm trying to retrieve a cell value from one sheet to another where it looks up the ID# and retrieves the Score. However, I want it to retrieve the most recent Score, because the sheet it is retrieving from is a historical record with many different scores assigned to that ID# over time. Could someone help me with the formula? Thanks!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!