Join Collect output, need help filtering.

I have a formula that is working correctly for how it is written but still isn't providing me the results I want.

=JOIN(COLLECT({Purchasing Log_FM0052 Rev. B Range 3}, {Purchasing Log_FM0052 Rev. B Range 1}, [MIS P/N]@row, {Purchasing Log_FM0052 Rev. B Range 4}, ="Open"), ", ")

="Open" is pulling from a field with four values, Open, Closed, Void, and Sent. With the way the formula is now it only returns the value for "Open", I'd like it to also include the values for "Sent".

I feel like I cant be that far away, but cant get over the hump. Any help will be appreciated. Thank you.

Find more posts tagged with

Accepted answers

Paul Newcome

Try this...

=JOIN(COLLECT({Purchasing Log_FM0052 Rev. B Range 3}, {Purchasing Log_FM0052 Rev. B Range 1}, [MIS P/N]@row, {Purchasing Log_FM0052 Rev. B Range 4}, OR(@cell = "Open", @cell = "Sent")), ", ")

All comments

Paul Newcome

Try this...

=JOIN(COLLECT({Purchasing Log_FM0052 Rev. B Range 3}, {Purchasing Log_FM0052 Rev. B Range 1}, [MIS P/N]@row, {Purchasing Log_FM0052 Rev. B Range 4}, OR(@cell = "Open", @cell = "Sent")), ", ")

Chris Benskin

Paul

Thank you. I felt it could be done with an OR statement but I just couldn't wrap my mind around how to do it.

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.