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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!