@Raul Cabrera<\/a> ,<\/p>Give this try.<\/p>
=IF(ETS@row = \"//www.santa-greenland.com/community/discussion/29906/\", [Business_Dropdown]@row, IF(ETS@row = \"EAS\", \"EAS\", IF(ETS@row = \"ETS\", \"ETS\")))<\/p>
Hope this helps,<\/p>
Dave<\/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":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":110951,"type":"question","name":"Formula Help For Multiple Tags Within The Same Cell","excerpt":"Hey All! First time posting... so here goes... I am attempting to write a formula that references another sheet, looks at a specific column, and then 'finds and counts' all the instances of a specific tag. For example, the intake form allows multiple 'characteristics' to be chosen when describing a call. These…","snippet":"Hey All! First time posting... so here goes... I am attempting to write a formula that references another sheet, looks at a specific column, and then 'finds and counts' all the…","categoryID":322,"dateInserted":"2023-09-28T19:18:37+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T20:04:52+00:00","insertUserID":166984,"insertUser":{"userID":166984,"name":"EmRo","title":"Senior Operations Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/EmRo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T20:00:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":166984,"lastUser":{"userID":166984,"name":"EmRo","title":"Senior Operations Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/EmRo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T20:00:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":22,"score":null,"hot":3391862009,"url":"https:\/\/community.smartsheet.com\/discussion\/110951\/formula-help-for-multiple-tags-within-the-same-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110951\/formula-help-for-multiple-tags-within-the-same-cell","format":"Rich","lastPost":{"discussionID":110951,"commentID":397526,"name":"Re: Formula Help For Multiple Tags Within The Same Cell","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397526#Comment_397526","dateInserted":"2023-09-28T20:04:52+00:00","insertUserID":166984,"insertUser":{"userID":166984,"name":"EmRo","title":"Senior Operations Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/EmRo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T20:00:35+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/44ABE1FHZKC6\/call-categories-dashboard-image-2023-09-28.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Call Categories Dashboard_Image_2023-09-28.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-28T20:03:55+00:00","dateAnswered":"2023-09-28T19:57:29+00:00","acceptedAnswers":[{"commentID":397521,"body":"
Hi @EmRo<\/a> ,<\/p>Trying using the HAS() function in your formula.<\/p>
=COUNTIF({Client Business Sim LIVE Call Characteristic}, HAS(@cell, Description@row))<\/p>
Hope this helps,<\/p>
Dave<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">