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.

Find more posts tagged with

Accepted answers

All comments

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?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.