Formulas and Functions

If the staff are only working at an option in 1 column at a time you can do this with a simple JOIN:<\/p>

=JOIN([Austin Clinics]@row:[Rio Grande Clinics]@row)<\/p>

This will combine all of the columns, but as 3 are blank it will just show the 1 they are at.<\/p>

If this isn't the case or I've missed something then let me know and we'll see if we can puzzle an alternative out! 😊<\/span><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":107502,"type":"question","name":"Using CONTAINS with JOIN(COLLECT)","excerpt":"Hello! I'm trying to add CONTAINS to an existing JOIN(COLLECT) formula, and I can't seem to get it to work. The existing (working) formula is: =JOIN(COLLECT({RAID Log Title}, {RAID Log Flag}, \"1\", {RAID Log Category}, \"Issue\", {RAID Log Top 10 Priority}, [Priority Name]@row), \", \"). The formula I've come up with to add…","snippet":"Hello! I'm trying to add CONTAINS to an existing JOIN(COLLECT) formula, and I can't seem to get it to work. The existing (working) formula is: =JOIN(COLLECT({RAID Log Title},…","categoryID":322,"dateInserted":"2023-07-12T15:40:14+00:00","dateUpdated":"2023-07-12T16:01:55+00:00","dateLastComment":"2023-07-12T17:05:17+00:00","insertUserID":161010,"insertUser":{"userID":161010,"name":"scisar","url":"https:\/\/community.smartsheet.com\/profile\/scisar","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-12T17:41:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":91566,"lastUserID":161010,"lastUser":{"userID":161010,"name":"scisar","url":"https:\/\/community.smartsheet.com\/profile\/scisar","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-12T17:41:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":16,"score":null,"hot":3378359131,"url":"https:\/\/community.smartsheet.com\/discussion\/107502\/using-contains-with-join-collect","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107502\/using-contains-with-join-collect","format":"Rich","lastPost":{"discussionID":107502,"commentID":384838,"name":"Re: Using CONTAINS with JOIN(COLLECT)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384838#Comment_384838","dateInserted":"2023-07-12T17:05:17+00:00","insertUserID":161010,"insertUser":{"userID":161010,"name":"scisar","url":"https:\/\/community.smartsheet.com\/profile\/scisar","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-12T17:41:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-12T16:55:06+00:00","dateAnswered":"2023-07-12T16:08:17+00:00","acceptedAnswers":[{"commentID":384815,"body":"