Index Match Function


I am trying to mimic an Index (Match) formula in smartsheet.

When a drop down is selected, on grid 1, a different column will autopopulate with a related data. This is the formula in Excel. I don't know how to create this in smartsheet.

Sheet 1 - is grid I am referencing and it is feeding into Sheet 2 (activity)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!