Formulas and Functions

1, [Paid Date]@row > TODAY() - 365), \"3. To Be Closed\", \"2.Waiting on Payment\")) When I do just this it…","categoryID":322,"dateInserted":"2021-04-09T14:12:08+00:00","dateUpdated":null,"dateLastComment":"2021-04-09T14:52:56+00:00","insertUserID":133576,"insertUser":{"userID":133576,"name":"Jared Pietila","url":"https:\/\/community.smartsheet.com\/profile\/Jared%20Pietila","photoUrl":"https:\/\/lh6.googleusercontent.com\/-YgWCdhcuym0\/AAAAAAAAAAI\/AAAAAAAAAAA\/AMZuuclAQYQ3mxplYXVmz_wGb5RIHKsacQ\/s96-c\/photo.jpg","dateLastActive":"2023-04-06T15:22:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-20T03:23:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":41,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/78194\/mulitiple-if-statements-in-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78194\/mulitiple-if-statements-in-a-formula","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-09T14:52:56+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":78172,"type":"question","name":"How to write formula to auto check a column","excerpt":"I have a sheet that tracks our AP process. Three of the four types of payment requests we get require another step. One does not. I would like to have the \"next step\" column auto check when the \"payment request type\" is that one anomaly. This can be flied under \"are you new here, or what.\" The answer is , \"yes.\" I've…","categoryID":322,"dateInserted":"2021-04-08T21:32:20+00:00","dateUpdated":null,"dateLastComment":"2021-04-09T14:48:24+00:00","insertUserID":120803,"insertUser":{"userID":120803,"name":"Gina Adrien","url":"https:\/\/community.smartsheet.com\/profile\/Gina%20Adrien","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xdHW8R9rNf4!5IdUuUdWazo!y38YQ9jOi3l","dateLastActive":"2023-03-23T16:20:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-19T20:19:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":107,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/78172\/how-to-write-formula-to-auto-check-a-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78172\/how-to-write-formula-to-auto-check-a-column","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-08T23:42:51+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":78190,"type":"question","name":"Nested ISBLANK Formula","excerpt":"Hi I want to be able to look up changes to e.g. employee name, Job Title etc in a sheet and update the any changes on a staff sheet. However, if for example, their job title hasn't changed I need the formula to refer to 'old job title' column. I have a unique identifier of the Employee ID so, wondered if an INDEX MATCH…","categoryID":322,"dateInserted":"2021-04-09T12:27:40+00:00","dateUpdated":null,"dateLastComment":"2021-04-09T14:47:07+00:00","insertUserID":125322,"insertUser":{"userID":125322,"name":"Cheryl Collins","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Cheryl%20Collins","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ujDUd8trmpQ!HMFV36dbhPo!OB9bg9sjUrN","dateLastActive":"2023-08-11T06:44:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-20T03:23:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":82,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/78190\/nested-isblank-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78190\/nested-isblank-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-04-09T14:29:06+00:00","dateAnswered":"2021-04-09T14:16:06+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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}]},{"discussionID":78192,"type":"question","name":"Date Functions","excerpt":"I am working on a Marketing request form for outside vendors and am curious if a rule can be applied that a due date cannot be before the form was submitted. For example, if a request comes in on 1\/1, the requestor cannot ask for a due date before 1\/15.","categoryID":322,"dateInserted":"2021-04-09T13:25:07+00:00","dateUpdated":null,"dateLastComment":"2021-04-09T13:51:24+00:00","insertUserID":134804,"insertUser":{"userID":134804,"name":"Christine Stepp","url":"https:\/\/community.smartsheet.com\/profile\/Christine%20Stepp","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!petMaWDasXQ!U9_MX_jTRPw!DO8UeO4Nyhz","dateLastActive":"2021-04-09T15:25:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-20T03:23:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":64,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/78192\/date-functions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78192\/date-functions","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-09T13:51:24+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":78154,"type":"question","name":"Search within all multi-selected fields for duplicates","excerpt":"Hi, I am wondering if there is a way to detect when there are duplicates of a multi-selected item in another row. My formula so far: =IF(OR(ISBLANK(Checkin@row), ISBLANK(Checkout@row)), \"//www.santa-greenland.com/community/categories/formulas-and-functions/\", IF(COUNTIFS(Checkout:Checkout, >=(Checkin@row + 1), Checkin:Checkin, <=(Checkout@row - 1), SiteNumber:SiteNumber, SiteNumber@row) - 1…","categoryID":322,"dateInserted":"2021-04-08T17:38:11+00:00","dateUpdated":null,"dateLastComment":"2021-04-09T13:13:34+00:00","insertUserID":129839,"insertUser":{"userID":129839,"name":"Rylan Funk","url":"https:\/\/community.smartsheet.com\/profile\/Rylan%20Funk","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-04-15T14:59:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":127476,"lastUser":{"userID":127476,"name":"Leibel S","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Leibel%20S","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-17T17:47:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":61,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/78154\/search-within-all-multi-selected-fields-for-duplicates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78154\/search-within-all-multi-selected-fields-for-duplicates","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/VVQJUD8IZSYF\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-09T13:13:34+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":78187,"type":"question","name":"If Then Help","excerpt":"I'd like to have a main input cell for # of items being shipped. Sheet is being set up to ship 40 items. I'd like to have 4 other cells which populate based on the main cell's value. (Example 1) Main Cell: 5 Cell 1 (0-10 Items): 5 Cell 2 (10-20 Items): 0 Cell 3 (20-30 Items): 0 Cell 4 (30-40 Items): 0 (Example 2) Main…","categoryID":322,"dateInserted":"2021-04-09T10:46:42+00:00","dateUpdated":null,"dateLastComment":"2021-04-09T12:13:41+00:00","insertUserID":134712,"insertUser":{"userID":134712,"name":"Jared Hernandez","url":"https:\/\/community.smartsheet.com\/profile\/Jared%20Hernandez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-05-03T18:15:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-20T03:23:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":41,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/78187\/if-then-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78187\/if-then-help","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-09T12:13:41+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":77326,"type":"question","name":"Total Time Taken","excerpt":"Good afternoon all, Here we are again, another question about summing up time. I have trawled the forums and cannot find an answer that helps me specifically so I'm hoping that reaching out on here will do so. I have 2 columns - Start Time and Finish Time, the time is put into each in HH:MM format. I would like another…","categoryID":322,"dateInserted":"2021-03-16T13:19:20+00:00","dateUpdated":null,"dateLastComment":"2021-04-09T10:19:17+00:00","insertUserID":128231,"insertUser":{"userID":128231,"name":"Lee Wood","url":"https:\/\/community.smartsheet.com\/profile\/Lee%20Wood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-05T06:32:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":128231,"lastUser":{"userID":128231,"name":"Lee Wood","url":"https:\/\/community.smartsheet.com\/profile\/Lee%20Wood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-05T06:32:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":114,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/77326\/total-time-taken","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/77326\/total-time-taken","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-03-16T14:02:04+00:00","dateAnswered":"2021-03-16T13:58:38+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":78134,"type":"question","name":"when i hover over filters the edit icon is at the bottom of the filters therefore i can not access i","excerpt":"when i hover over filters the edit icon is at the bottom of the filters therefore i can not access it please help the ","categoryID":322,"dateInserted":"2021-04-08T13:31:24+00:00","dateUpdated":null,"dateLastComment":"2021-04-09T10:14:28+00:00","insertUserID":134722,"insertUser":{"userID":134722,"name":"Aaron Conley","url":"https:\/\/community.smartsheet.com\/profile\/Aaron%20Conley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-04-08T16:17:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-19T18:57:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":82,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/78134\/when-i-hover-over-filters-the-edit-icon-is-at-the-bottom-of-the-filters-therefore-i-can-not-access-i","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78134\/when-i-hover-over-filters-the-edit-icon-is-at-the-bottom-of-the-filters-therefore-i-can-not-access-i","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-09T10:14:28+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":78177,"type":"question","name":"is there a formula i can use for the below","excerpt":"is there a formula i can use i have a form which i use for staff hours when they input start time an finish time i want it to automatically add it to total time","categoryID":322,"dateInserted":"2021-04-09T00:40:02+00:00","dateUpdated":null,"dateLastComment":"2021-04-09T06:07:12+00:00","insertUserID":129116,"insertUser":{"userID":129116,"name":"aaron tuheke","url":"https:\/\/community.smartsheet.com\/profile\/aaron%20tuheke","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-04-09T01:10:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":54461,"lastUser":{"userID":54461,"name":"Lachlan Stead","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Lachlan%20Stead","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KYHM5LPXEDDI\/nL23I8SPFO1OO.jpg","dateLastActive":"2023-08-11T11:23:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":51,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/78177\/is-there-a-formula-i-can-use-for-the-below","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78177\/is-there-a-formula-i-can-use-for-the-below","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/7EDG12NF028L\/11-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"11.JPG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-09T06:07:12+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":78175,"type":"question","name":"Using HAS with Multi-Selection Dropdown","excerpt":"Hi, I have a multi-selection dropdown with region selections. Next to that column I have the regions. For reporting purposes I need the column for each region to say \"Yes\" or \"No\" based on the items selected in the multi-select dropdown. I've created this formula with a variation for each column: =IF(HAS(\"Central\",…","categoryID":322,"dateInserted":"2021-04-08T22:18:05+00:00","dateUpdated":null,"dateLastComment":"2021-04-09T02:43:50+00:00","insertUserID":105446,"insertUser":{"userID":105446,"name":"Elliot Holder","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Elliot%20Holder","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-02-03T19:07:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":126171,"lastUser":{"userID":126171,"name":"Mark Cronk","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mark%20Cronk","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9UVGVH5TN00I\/nO060PSRF4UVU.jpg","dateLastActive":"2023-05-10T19:07:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":145,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/78175\/using-has-with-multi-selection-dropdown","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78175\/using-has-with-multi-selection-dropdown","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/L43O92CKKCB1\/screenshot-2021-04-08-171641.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2021-04-08 171641.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-09T02:43:50+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Help Article Resources