Formulas and Functions

=COUNTIFS({New RT - Priority}, [Column2]$28, {New RT - Platform}, HAS(@cell, \"CASI\")<\/strong>)<\/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":107379,"type":"question","name":"How to find duplicates in the document name column?","excerpt":"There are more than 700 documents and I want to find duplicate rows, I am new to Smartsheet.","snippet":"There are more than 700 documents and I want to find duplicate rows, I am new to Smartsheet.","categoryID":322,"dateInserted":"2023-07-10T12:57:20+00:00","dateUpdated":"2023-07-10T13:23:10+00:00","dateLastComment":"2023-07-10T13:05:27+00:00","insertUserID":163271,"insertUser":{"userID":163271,"name":"Umar Farooq","title":"MR","url":"https:\/\/community.smartsheet.com\/profile\/Umar%20Farooq","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-10T13:22:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":163271,"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-07-10T16:13:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":17,"score":null,"hot":3377988767,"url":"https:\/\/community.smartsheet.com\/discussion\/107379\/how-to-find-duplicates-in-the-document-name-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107379\/how-to-find-duplicates-in-the-document-name-column","format":"Rich","lastPost":{"discussionID":107379,"commentID":384335,"name":"Re: How to find duplicates in the document name column?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384335#Comment_384335","dateInserted":"2023-07-10T13:05:27+00:00","insertUserID":45516,"insertUser":{"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-07-10T16:13:50+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-10T13:23:23+00:00","dateAnswered":"2023-07-10T13:05:27+00:00","acceptedAnswers":[{"commentID":384335,"body":"

Try this in a checkbox or flag type column:<\/p>

=IF(COUNTIFS([Document Name]:[Document Name], @cell = [Document Name]@row)> 1, 1)<\/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":107353,"type":"question","name":"COUTM in one column IF \"OPEN\" and\/or \"Planning Stage\" in another","excerpt":"I understand the concept of COUNTM in a multi-dropdown in a cell... question is how to only count multiple selections in one cell in a row when a cell in another row is \"OPEN\" and\/or \"Planning Stage\". The formula I've been trying is... =COUNTM({Type of Equipment - APX All-band}, IF({Mission Status}, \"Open\", IF({Mission…","snippet":"I understand the concept of COUNTM in a multi-dropdown in a cell... question is how to only count multiple selections in one cell in a row when a cell in another row is \"OPEN\"…","categoryID":322,"dateInserted":"2023-07-07T20:11:57+00:00","dateUpdated":null,"dateLastComment":"2023-07-10T16:05:08+00:00","insertUserID":146662,"insertUser":{"userID":146662,"name":"Beckstrm","url":"https:\/\/community.smartsheet.com\/profile\/Beckstrm","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-10T16:06:54+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-07-10T16:13:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":46,"score":null,"hot":3377768825,"url":"https:\/\/community.smartsheet.com\/discussion\/107353\/coutm-in-one-column-if-open-and-or-planning-stage-in-another","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107353\/coutm-in-one-column-if-open-and-or-planning-stage-in-another","format":"Rich","lastPost":{"discussionID":107353,"commentID":384401,"name":"Re: COUTM in one column IF \"OPEN\" and\/or \"Planning Stage\" in another","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384401#Comment_384401","dateInserted":"2023-07-10T16:05:08+00:00","insertUserID":45516,"insertUser":{"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-07-10T16:13:50+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\/7TEJKD4QLZCQ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-10T15:48:26+00:00","dateAnswered":"2023-07-10T12:31:06+00:00","acceptedAnswers":[{"commentID":384322,"body":"

You need a COLLECT function.<\/p>

=COUNTM(COLLECT({Type of Equipment - APX All-band}, {Mission Status}, OR(@cell = \"Open\", @cell = \"Planning Stage\")))<\/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":[]}">