INDEX/MATCH formula question

I am currently working to manage a portfolio of projects and am trying to write a formula to pull data from one sheet that includes a crop type associated with a trial ID, into another sheet where I just want the crop type to populate in a given cell. The formulas I am trying to write is :

=INDEX({Trial ID},[Trial ID]@row, MATCH({Crop column},[Crop: Crop], $[Crop]@row))

Unfortunately, no matter what the edit is that I do, I continue to receive the "unparseable" error message.

Can anyone help with this? I am somewhat new to smartsheet and am not sure what fixes I need to make.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!