nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

INDEX/COLLECT/CONTAINS

L. Barrett

I need to pull the Form ID (and other columns) from Sheet B into Sheet A.

These conditions all need to be met:

Departure Date ⇒ Date Field 1

Departure Date =< Date Field 2

Destination (Sheet B) contains City (Sheet A)

Name (Sheet B) contains Last Name (Sheet A)

This is the current formula I have:

=INDEX(COLLECT({Form ID}, {Departure Date},=> [One Day Before Start]@row, {Departure Date}, =<[Meeting End Date]@row, {Destination}, CONTAINS(City@row, @cell ), {Traveler Name}, CONTAINS([Traveler Last Name]@row, @cell )), 1)

I am getting an Unparseable Error.

Any ideas?

Find more posts tagged with

Accepted answers

Paul Newcome

What does this do?

=INDEX(COLLECT({Form ID}, {Departure Date},@cell >= [One Day Before Start]@row, {Departure Date}, @cell <= [Meeting End Date]@row, {Destination}, CONTAINS(City@row, @cell), {Traveler Name}, CONTAINS([Traveler Last Name]@row, @cell)), 1)

All comments

Paul Newcome

What does this do?

L. Barrett

That worked, thanks!!!!

Paul Newcome

Happy to help. 👍️

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.