Looking to Resolve #NO MATCH with a Multi-select Dropdown

I've tried many variations and got very close with:

=IF(CONTAINS("Orientation", Course@row), INDEX({Course Start Date}, MATCH(Course@row, {Courses Dropdown Name}, 0)), "") - it only pulls when there is one selection provided in the multi-select dropdown and a "#NO MATCH" where there are more than one course selected.

We have 3 different classes every month with different start dates and want to capture the start date for that particular student.

Hope I've provided enough information to find a solution.

Find more posts tagged with

Formulas

Accepted answers

All comments

Danielle Arteaga

Hi, Rhonda:

To give you a specific formula suggestion, I'd need to see the column names on your sheet. But, I think I get the gist of what you're trying to do. To help, take a look at this prior answer: https://community.smartsheet.com/discussion/97044/help-combining-if-index-match

Hope this helps!

RhondaRhocks

Thanks Danielle,

Ironically I'm putting this process together for a Danielle. :)

Thanks but I didn't see that previous answer applied-the formula does work and the field types are matching and it works when an employee has requested one training and get #NO MATCH where there is more than one option selected.

Source "Courses" SS

This is where I need the date to fall into these 3 columns

Any help appreciated.

Eric Law

@RhondaRhocks Hey Rhonda, quick comment first, it will be helper to @username someone when you are replying as some people do not always remember all the pages they commented on. The only person that gets notified is the creator. With that said, you cannot INDEX/MATCH a multi-select dropdown.

RhondaRhocks

Thanks @Eric Law for this tip!

@Danielle Arteaga thanks for your help.

I did come up with a work around by standardizing the course titles - all most there! Used an =IF(CONTAINS("Orientation", Course@row), RIGHT(Course@row, 17)) to come up with the date range at right. I'm not sure if having a date range will work as a trigger though.

Looking for to trim the end date.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.