Novice Smartsheet User! Need help with Matching/Indexing

I need help with a formula! I'll try to explain this as clearly as I can.

I need a formula that can tell me the value I circled looking within the range of columns "01. Kick-Off Meeting" to "13. New Contract Start", based on the corresponding "Task Name" column, in this example, "Kick-Off Meeting" if the "Task Status" column is "Milestone".

The formula would go under "Task Status" where the cell is selected in the image.

These two images are from the same sheet.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

What is the formula you are currently using?

glokang

@Paul Newcome - none at the moment 😬

glokang

@Paul Newcome Hoping this provides additional reference...

In Excel, the formula would look like this:

=INDEX($J$5:$L$5,1,MATCH($C5,$J$4:$L$4,0))

For the highlighted column below:

I want to be able to replicate this in Smartsheet but I wasn't sure how to do it since you can't cross reference columns (or can you?)

Paul Newcome

The syntax would be pretty much identical except you can't reference column headers themselves. You would need a row in the sheet that has the column names the same way you have a row in the Excel workbook that has the column names.

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.