I want to filter data with given conditions using comma and string columns
Jared Pietila
✭✭✭
This formula kicks back all jobs in {FM & CapEx PBR Range 1}, I want to only kick out jobs that have "Brad" listed at the project manager
=JOIN(DISTINCT({FM & CapEx PBR Range 1}), ",") + ","
Answers

I think you might want the COLLECT function: COLLECT Function  Smartsheet Learning Center
You insert the COLLECT function into the place in the formula where the {FM & CapEx PBR Range 1} range is. The COLLECT function has a place for you to specify a criterion (eg. "Brad") to look for inside a range so that the range that the COLLECT function gives to the other function is just a subset of the original range.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.2K Get Help
 360 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!