Join Collect output, need help filtering.

Chris Benskin

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.

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")), ", ")

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. 👍️