Discussions
=[Column2]@row, {NESV Tracker Range 2}, <=[Column3]@row) I get 0's when there should be different results. If I do \"5GC\" alone…","categoryID":322,"dateInserted":"2023-03-16T16:37:59+00:00","dateUpdated":null,"dateLastComment":"2023-03-17T13:31:42+00:00","insertUserID":155082,"insertUser":{"userID":155082,"name":"Cristian","url":"https:\/\/community.smartsheet.com\/profile\/Cristian","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTte5k4hiADLB7GFKal1s-nnU-FnQ_L2FkiO-WId3KOesiPU=s96-c","dateLastActive":"2023-07-13T16:44:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":155082,"lastUser":{"userID":155082,"name":"Cristian","url":"https:\/\/community.smartsheet.com\/profile\/Cristian","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTte5k4hiADLB7GFKal1s-nnU-FnQ_L2FkiO-WId3KOesiPU=s96-c","dateLastActive":"2023-07-13T16:44:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":62,"score":null,"hot":3358045781,"url":"https:\/\/community.smartsheet.com\/discussion\/102756\/countifs","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/102756\/countifs","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/47UN2M4RJP45\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-03-17T04:53: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":102509,"type":"question","name":"How to remove flags with no link date available","excerpt":"Hello I have a flag column with this formula: =IF([Start of NESV Validation]@row < TODAY(-30), 1) The formula works fine when the \"Start of NESV Validation\" column has a date available. But when there's no date present, a red flag still shows. How can I leave the flag space blank if no date is available? If have also tried…","categoryID":322,"dateInserted":"2023-03-13T13:34:06+00:00","dateUpdated":"2023-03-13T13:36:06+00:00","dateLastComment":"2023-03-13T17:50:03+00:00","insertUserID":155082,"insertUser":{"userID":155082,"name":"Cristian","url":"https:\/\/community.smartsheet.com\/profile\/Cristian","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTte5k4hiADLB7GFKal1s-nnU-FnQ_L2FkiO-WId3KOesiPU=s96-c","dateLastActive":"2023-07-13T16:44:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"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":5,"countViews":55,"score":null,"hot":3357447249,"url":"https:\/\/community.smartsheet.com\/discussion\/102509\/how-to-remove-flags-with-no-link-date-available","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/102509\/how-to-remove-flags-with-no-link-date-available","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/DVFQE4EJ1WA5\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-03-14T07:10:41+00:00","dateAnswered":"2023-03-13T17:35:47+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":102473,"type":"question","name":"Countifs for records older then set date.","excerpt":"Hello I am looking for help on the countifs formula. I have a sheet with many entries. I need to find entriers added before a specific date. NOTE: I don't have a date column in my sheet. Here's the formula I am trying to use but its not working: =COUNTIFS({NESV Tracker Range 1}, \"EPC\", <=DATE(2023, 1, 6)) Any help would be…","categoryID":322,"dateInserted":"2023-03-11T00:03:50+00:00","dateUpdated":null,"dateLastComment":"2023-03-13T11:09:42+00:00","insertUserID":155082,"insertUser":{"userID":155082,"name":"Cristian","url":"https:\/\/community.smartsheet.com\/profile\/Cristian","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTte5k4hiADLB7GFKal1s-nnU-FnQ_L2FkiO-WId3KOesiPU=s96-c","dateLastActive":"2023-07-13T16:44:41+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":1,"countViews":47,"score":null,"hot":3357199412,"url":"https:\/\/community.smartsheet.com\/discussion\/102473\/countifs-for-records-older-then-set-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/102473\/countifs-for-records-older-then-set-date","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-03-13T11:09:42+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":100908,"type":"question","name":"Data Shuttle","excerpt":"Hello I am new to data shuttle. My team gets weekly emails in the form of csv files with new equipment that was added for that week. These emails are sent to us every Monday morning. We normally take the new equipment added for that week (copy\/paste) into a Smartsheet repository (sheet). Is there a way to take this…","categoryID":343,"dateInserted":"2023-02-09T14:13:12+00:00","dateUpdated":null,"dateLastComment":"2023-02-18T15:06:24+00:00","insertUserID":155082,"insertUser":{"userID":155082,"name":"Cristian","url":"https:\/\/community.smartsheet.com\/profile\/Cristian","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTte5k4hiADLB7GFKal1s-nnU-FnQ_L2FkiO-WId3KOesiPU=s96-c","dateLastActive":"2023-07-13T16:44:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":152988,"lastUser":{"userID":152988,"name":"Danielle Wilson","url":"https:\/\/community.smartsheet.com\/profile\/Danielle%20Wilson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZZDXWctIdZQ!BrDQwSiqPOQ!J3oBfQ3Wq2i","dateLastActive":"2023-08-23T12:42:10+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":162,"score":null,"hot":3352690176,"url":"https:\/\/community.smartsheet.com\/discussion\/100908\/data-shuttle","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100908\/data-shuttle","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-09T14:41:37+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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":100961,"type":"question","name":"Formula Translation","excerpt":"Is there an equivalent formula for \"UNIQUE\" that I can use in Smartsheet? Here's the excel formula I am using: =unique(C2:C130) The output is six unique elements taken from column C.","categoryID":322,"dateInserted":"2023-02-10T00:19:02+00:00","dateUpdated":null,"dateLastComment":"2023-02-10T17:17:49+00:00","insertUserID":155082,"insertUser":{"userID":155082,"name":"Cristian","url":"https:\/\/community.smartsheet.com\/profile\/Cristian","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTte5k4hiADLB7GFKal1s-nnU-FnQ_L2FkiO-WId3KOesiPU=s96-c","dateLastActive":"2023-07-13T16:44:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":11072,"lastUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-08-23T14:56:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":163,"score":null,"hot":3352040211,"url":"https:\/\/community.smartsheet.com\/discussion\/100961\/formula-translation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100961\/formula-translation","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/52GBFXDVV7GA\/2023-02-09-19-17-32-window.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"2023-02-09 19_17_32-Window.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-10T00:59:45+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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":false,"noCheckboxes":true}">