Add Ons and Integrations

<\/p>

<\/p>

<\/p>

<\/p>

<\/p>

<\/p>

<\/p>

<\/p>

I hope that helps.<\/p>

Matt<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-17 15:25:45","updateUser":{"userID":156927,"name":"RBrewster","url":"https:\/\/community.smartsheet.com\/profile\/RBrewster","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wpnD_10buz8!!zTQUSWC76x7","dateLastActive":"2023-02-17T17:30:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":101327,"type":"question","name":"formula work one one sheet but not another","excerpt":"Hello I have a formula =IF(COUNTIF(IndexKey:IndexKey, IndexKey@row > 1), 1, 0) that checks all the indexkeys in the column to see if there are any duplicates. This works perfectly on my tester sheet which is an exact copy of the sheet I want the formula on but for some reason doesn't work on the main sheet and returns 0…","categoryID":321,"dateInserted":"2023-02-17T09:43:40+00:00","dateUpdated":null,"dateLastComment":"2023-02-17T09:45:15+00:00","insertUserID":156778,"insertUser":{"userID":156778,"name":"ross chambers","url":"https:\/\/community.smartsheet.com\/profile\/ross%20chambers","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-17T12:17:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":156778,"lastUser":{"userID":156778,"name":"ross chambers","url":"https:\/\/community.smartsheet.com\/profile\/ross%20chambers","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-17T12:17:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":3353254735,"url":"https:\/\/community.smartsheet.com\/discussion\/101327\/formula-work-one-one-sheet-but-not-another","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101327\/formula-work-one-one-sheet-but-not-another","format":"Rich","tagIDs":[219,254],"lastPost":{"discussionID":101327,"commentID":362908,"name":"Re: formula work one one sheet but not another","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/362908#Comment_362908","dateInserted":"2023-02-17T09:45:15+00:00","insertUserID":156778,"insertUser":{"userID":156778,"name":"ross chambers","url":"https:\/\/community.smartsheet.com\/profile\/ross%20chambers","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-17T12:17:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-17T09:45:23+00:00","dateAnswered":"2023-02-17T09:45:15+00:00","acceptedAnswers":[{"commentID":362908,"body":"

nevermind i had the bracket in the wrong place =IF(COUNTIF(IndexKey:IndexKey, IndexKey@row) > 1, 1, 0)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-17 09:45:23","updateUser":{"userID":156778,"name":"ross chambers","url":"https:\/\/community.smartsheet.com\/profile\/ross%20chambers","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-17T12:17:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":101310,"type":"question","name":"I am trying to identify duplicates on a sheet using a check box","excerpt":"I want to identify duplicates on a sheet using a check box but I want to ensure that 2 conditions are meet. If the amount is the same and the Internal Wire ID is the same. I am using this formula to look for matches in amount, =IF(COUNTIF(Amount:Amount, Amount@row) > 1, 1) but I am getting too many positive so I want to…","categoryID":321,"dateInserted":"2023-02-16T21:06:01+00:00","dateUpdated":null,"dateLastComment":"2023-02-17T13:27:47+00:00","insertUserID":132493,"insertUser":{"userID":132493,"name":"Dene Marcello","url":"https:\/\/community.smartsheet.com\/profile\/Dene%20Marcello","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-17T13:19:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":132493,"lastUser":{"userID":132493,"name":"Dene Marcello","url":"https:\/\/community.smartsheet.com\/profile\/Dene%20Marcello","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-17T13:19:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":34,"score":null,"hot":3353223228,"url":"https:\/\/community.smartsheet.com\/discussion\/101310\/i-am-trying-to-identify-duplicates-on-a-sheet-using-a-check-box","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101310\/i-am-trying-to-identify-duplicates-on-a-sheet-using-a-check-box","format":"Rich","lastPost":{"discussionID":101310,"commentID":362930,"name":"Re: I am trying to identify duplicates on a sheet using a check box","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/362930#Comment_362930","dateInserted":"2023-02-17T13:27:47+00:00","insertUserID":132493,"insertUser":{"userID":132493,"name":"Dene Marcello","url":"https:\/\/community.smartsheet.com\/profile\/Dene%20Marcello","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-17T13:19:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-17T14:29:04+00:00","dateAnswered":"2023-02-16T21:46:23+00:00","acceptedAnswers":[{"commentID":362847,"body":"

you should be able to use =IF(COUNTIFS(Amount:Amount, Amount@row, [Internal Wire ID]:[Internal Wire ID], [Internal Wire ID]@row) > 1, 1) <\/p>

When a column name has more than one word it needs to be in brackets [column name]<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-17 14:29:04","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-02-19T19:16:34+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">