How do I use AND within Join Collect?

Im trying to collect and Join names of vendors where the delivery date is greater than or equal to one cell and less than or equal to another cell. i just cant seem to get the syntax right. Below is my current formula. Am i using the AND formula incorrectly?

=JOIN(COLLECT({Glass Orders Range 1}, {Glass Orders Range 2}, AND(>=[Date in Final]22, <=[Date in Final]25)))

Find more posts tagged with

Formulas

Accepted answers

jjg279

I think you just need to add the cell to evaluate for your AND formula, and a delimiter if you want:

=JOIN(COLLECT({Glass Orders Range 1}, {Glass Orders Range 2}, AND(@cell>=[Date in Final]22, @cell<=[Date in Final]25)), "Delimiter if you want one")

All comments

jjg279

I think you just need to add the cell to evaluate for your AND formula, and a delimiter if you want:

=JOIN(COLLECT({Glass Orders Range 1}, {Glass Orders Range 2}, AND(@cell>=[Date in Final]22, @cell<=[Date in Final]25)), "Delimiter if you want one")

Brandon Morales

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.