INDEX/MATCH formula question

AdamsR

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.

Darla Brown

Hi,

Have you tried:

=INDEX({Trial ID}, MATCH(Crop@row,{Crop column},0))

AdamsR

Hi Darla, Thank you for input! I tried that first and no luck. Still populates unparseable.

Paul Newcome

Are you able to provide a screenshot of the formula opened in the sheet as if you are getting ready to edit it?