Formulas and Functions

4 \/ 1 \/ 21, [Start Date]:[Start Date]<06\/30\/21))","categoryID":322,"dateInserted":"2021-04-19T17:55:11+00:00","dateUpdated":null,"dateLastComment":"2021-04-20T12:56:50+00:00","insertUserID":122645,"insertUser":{"userID":122645,"name":"Kimberly Washeleski","url":"https:\/\/community.smartsheet.com\/profile\/Kimberly%20Washeleski","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-04-20T12:57:42+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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":1673,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/78526\/creating-a-date-range","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78526\/creating-a-date-range","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-19T19:13:43+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":78553,"type":"question","name":"Supplier management","excerpt":"Hello. I would like to monitor a group of suppliers to whom I send a questionnaire. Is it possible to automate a mailing every 6 months, for example ? Is it possible to send 2 attached documents via Smartsheet ? How can I do this ? Is it possible to manage the return of this questionnaire in my database ? How can I manage…","categoryID":322,"dateInserted":"2021-04-20T11:49:08+00:00","dateUpdated":null,"dateLastComment":"2021-04-20T12:35:46+00:00","insertUserID":129313,"insertUser":{"userID":129313,"name":"Christophe AUBRIOT","url":"https:\/\/community.smartsheet.com\/profile\/Christophe%20AUBRIOT","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-04-08T06:29:38+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-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":61,"score":null,"hot":3237842094,"url":"https:\/\/community.smartsheet.com\/discussion\/78553\/supplier-management","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78553\/supplier-management","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-20T12:35:46+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":75733,"type":"discussion","name":"Removing all of the irrelevant footer information added by Smartsheet to Automation emails","excerpt":"We are using automation to external workers to update smartsheet. We have a number of issues that have been aired before. The smartsheet owners name appearing in the email address. Confuses the worker when the sheet owner does not interact with worker. Only option is to use a licence and set it up as a general name so that…","categoryID":322,"dateInserted":"2021-02-04T12:45:29+00:00","dateUpdated":null,"dateLastComment":"2021-04-20T12:35:32+00:00","insertUserID":121678,"insertUser":{"userID":121678,"name":"Peter Briscall","url":"https:\/\/community.smartsheet.com\/profile\/Peter%20Briscall","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-03T16:17:12+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-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":true,"countComments":8,"countViews":371,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/75733\/removing-all-of-the-irrelevant-footer-information-added-by-smartsheet-to-automation-emails","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75733\/removing-all-of-the-irrelevant-footer-information-added-by-smartsheet-to-automation-emails","format":"Rich","groupID":null,"statusID":0,"attributes":{},"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":78542,"type":"question","name":"Index A Pivot Table","excerpt":"Does anyone have experience using Index on a pivot table? Or perhaps there is a better way. We use a pivot table to summarize various stages of the sales process (not contacted, needs contact, active priority, hot needs call, warm needs call, etc). I need to pull the summary numbers from that pivot table each week into a…","categoryID":322,"dateInserted":"2021-04-19T23:13:37+00:00","dateUpdated":null,"dateLastComment":"2021-04-20T12:06:06+00:00","insertUserID":131616,"insertUser":{"userID":131616,"name":"Andrea Westrich","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andrea%20Westrich","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!06vS_zj5Rrw!!Vj-bj4lNhSM","dateLastActive":"2023-08-23T17:05:22+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-25T17:46:09+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\/78542\/index-a-pivot-table","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78542\/index-a-pivot-table","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-20T12:06: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":[],"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":78537,"type":"question","name":"List Based on Date","excerpt":"Hello, I have a sheet with multiple columns. 2 of those columns are \"Name\" & \"Date\". If the date is older than 14 days, I would like to get a list from the Names as well as the Date. I don't need any of the other data from the other columns. Just a list with the names and dates of anything older than 14 days. Thanks","categoryID":322,"dateInserted":"2021-04-19T20:18:13+00:00","dateUpdated":null,"dateLastComment":"2021-04-20T11:51:08+00:00","insertUserID":135127,"insertUser":{"userID":135127,"name":"Drew Cooper","url":"https:\/\/community.smartsheet.com\/profile\/Drew%20Cooper","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7t9Uu1dWXPo!jMjXo084zRY!hC0LJv5JWL2","dateLastActive":"2021-12-09T22:59:01+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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":138,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/78537\/list-based-on-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78537\/list-based-on-date","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-19T20:19:30+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":78523,"type":"question","name":"SUMIF sum_range","excerpt":"Hello, I am trying to calculate the SUM in numerous columns based on if the Level Column contains certain text; e.g. SUMIF Level = L04 then SUM Column CAB 900 and I have this working with the formula =SUMIF(Level:Level, \"L04\", [CAB 900]:[CAB 900]) The problem I am having is that I will have 100+ columns and have to do this…","categoryID":322,"dateInserted":"2021-04-19T17:40:31+00:00","dateUpdated":null,"dateLastComment":"2021-04-20T11:50:00+00:00","insertUserID":121254,"insertUser":{"userID":121254,"name":"Emmet McKenna","url":"https:\/\/community.smartsheet.com\/profile\/Emmet%20McKenna","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!78Fdu7ADPPw!XUHeH5wWCP4!rCdPgh8oa0i","dateLastActive":"2023-08-17T12:23:18+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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":174,"score":null,"hot":10,"url":"https:\/\/community.smartsheet.com\/discussion\/78523\/sumif-sum-range","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78523\/sumif-sum-range","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-07-06T10:50:26+00:00","dateAnswered":"2021-04-19T21:14:01+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":78525,"type":"question","name":"Auto adding dropdown options?","excerpt":"Hi, I am trying to establish a training eval form which can pull training titles from an existing sheet as options for a dropdown menu. Any suggestions? @Genevieve P","categoryID":322,"dateInserted":"2021-04-19T17:50:02+00:00","dateUpdated":null,"dateLastComment":"2021-04-20T11:49:28+00:00","insertUserID":118995,"insertUser":{"userID":118995,"name":"PWells","title":"","url":"https:\/\/community.smartsheet.com\/profile\/PWells","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T21:27:47+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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":73,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/78525\/auto-adding-dropdown-options","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78525\/auto-adding-dropdown-options","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-04-19T21:18:50+00:00","dateAnswered":"2021-04-19T18:12: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":204,"urlcode":"forms","name":"Forms"}],"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":78038,"type":"question","name":"I need help with a #DIVIDE BY ZERO issue","excerpt":"Hi team, I have a formula where 4 columns figures are weighted in a 20\/80 split: =((([Energy & GHG assessment Completed in cycle]81 \/ [Energy & GHG assessment Expected in cycle]81) * 0,2)) + ((([E&GHG Completed Tasks (end reporting period)]81 \/ [E&GHG Expected tasks (end reporting period)]81) * 0,8)) If one of the scores…","categoryID":322,"dateInserted":"2021-04-06T12:51:49+00:00","dateUpdated":null,"dateLastComment":"2021-04-20T10:31:29+00:00","insertUserID":132670,"insertUser":{"userID":132670,"name":"Kris Miller","url":"https:\/\/community.smartsheet.com\/profile\/Kris%20Miller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-04-20T12:04:14+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-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":15,"countViews":133,"score":null,"hot":15,"url":"https:\/\/community.smartsheet.com\/discussion\/78038\/i-need-help-with-a-divide-by-zero-issue","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78038\/i-need-help-with-a-divide-by-zero-issue","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-04-20T10:31:09+00:00","dateAnswered":"2021-04-20T08:43:20+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":78531,"type":"question","name":"Formula to return a 1 if cell is between two weeks","excerpt":"I just started with Smartsheet 10 days ago and I just want to say this community is great! Up until now I've found the answer for every question I had on this forum. I'm trying to get DueNext2 to return a 1 if the Due column is within two weeks from today. It isn't working and I've tried everything I know (which is very…","categoryID":322,"dateInserted":"2021-04-19T19:08:52+00:00","dateUpdated":null,"dateLastComment":"2021-04-20T08:26:57+00:00","insertUserID":135169,"insertUser":{"userID":135169,"name":"Aaron Brown","url":"https:\/\/community.smartsheet.com\/profile\/Aaron%20Brown","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-04-29T21:16:28+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-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":61,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/78531\/formula-to-return-a-1-if-cell-is-between-two-weeks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78531\/formula-to-return-a-1-if-cell-is-between-two-weeks","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/EV4VPWVD9JIR\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2021-04-20T08:27:00+00:00","dateAnswered":"2021-04-19T19:56:18+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":78470,"type":"question","name":"Formulas to identify duplicates","excerpt":"My company is assigning decals to vehicles to monitor our guests. Is there a formula to identify if a license plate has already received a decal if I am looking at my sheet? We will have 2000+ license plates and need this to be a quick glance, or automated notification. I know I am asking a lot so any help is appreciated.","categoryID":322,"dateInserted":"2021-04-16T20:24:30+00:00","dateUpdated":"2021-04-16T20:25:25+00:00","dateLastComment":"2021-04-20T08:10:11+00:00","insertUserID":131184,"insertUser":{"userID":131184,"name":"Chevon Brownell","url":"https:\/\/community.smartsheet.com\/profile\/Chevon%20Brownell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-13T14:52:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":131184,"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-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":81,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/78470\/formulas-to-identify-duplicates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78470\/formulas-to-identify-duplicates","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-05-27T16:57:05+00:00","dateAnswered":"2021-04-20T08:10:11+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"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}],"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