Formulas and Functions

\"Complete\", [Target End Date]301 <= TODAY()), 1, 0) Currently, the column flags…","categoryID":322,"dateInserted":"2020-06-22T21:01:38+00:00","dateUpdated":null,"dateLastComment":"2021-02-03T16:58:05+00:00","insertUserID":122907,"insertUser":{"userID":122907,"name":"Titilope Akinlose","url":"https:\/\/community.smartsheet.com\/profile\/Titilope%20Akinlose","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-02-03T16:53:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":122907,"lastUser":{"userID":122907,"name":"Titilope Akinlose","url":"https:\/\/community.smartsheet.com\/profile\/Titilope%20Akinlose","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-02-03T16:53:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":363,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/69311\/smartsheet-at-risk-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69311\/smartsheet-at-risk-formula","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/MQCFRTESBHS0\/annotation-2020-06-22-165725.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Annotation 2020-06-22 165725.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-06-23T17:54:44+00:00","dateAnswered":"2020-06-23T12:43: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":[{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"}],"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":75668,"type":"question","name":"Collect Function with Multiple Criteria","excerpt":"I have the following collect function that works fine when I only have one criterion (the answer is 6) but, when I add the additional criterion to evaluate the Date I get an answer of 1 instead of the 6 I was expecting. Any help would be appreciated.","categoryID":322,"dateInserted":"2021-02-03T14:29:56+00:00","dateUpdated":null,"dateLastComment":"2021-02-03T16:56:11+00:00","insertUserID":124126,"insertUser":{"userID":124126,"name":"Loucas Tsiartas","url":"https:\/\/community.smartsheet.com\/profile\/Loucas%20Tsiartas","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-09-15T12:17:19+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-07-11T19:26:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":871,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/75668\/collect-function-with-multiple-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75668\/collect-function-with-multiple-criteria","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/OKJTP38I2S4H\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-02-03T15:42:02+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":74998,"type":"question","name":"Counting how many items are on the critical path","excerpt":"I know I can filter my task list and only show critical items and we are working on dashboards and I would like to count how many items are on the critical path, how many are done and what ones are past due or coming to their due date. I would like the formula to work from a reference sheet that I am building for my…","categoryID":322,"dateInserted":"2021-01-19T18:38:56+00:00","dateUpdated":null,"dateLastComment":"2021-02-03T16:22:24+00:00","insertUserID":129938,"insertUser":{"userID":129938,"name":"Sean Corcoran","url":"https:\/\/community.smartsheet.com\/profile\/Sean%20Corcoran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-25T17:32:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":129938,"lastUser":{"userID":129938,"name":"Sean Corcoran","url":"https:\/\/community.smartsheet.com\/profile\/Sean%20Corcoran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-25T17:32:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":192,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/74998\/counting-how-many-items-are-on-the-critical-path","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/74998\/counting-how-many-items-are-on-the-critical-path","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-02-03T16:22:32+00:00","dateAnswered":"2021-01-21T23:33:02+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":75681,"type":"question","name":"Why am i getting a error?","excerpt":"When i hit enter this says DIVIDE BY ZERO. do you know what my error is?","categoryID":322,"dateInserted":"2021-02-03T16:07:30+00:00","dateUpdated":null,"dateLastComment":"2021-02-03T16:19:19+00:00","insertUserID":121284,"insertUser":{"userID":121284,"name":"Jennifer Flanagan","url":"https:\/\/community.smartsheet.com\/profile\/Jennifer%20Flanagan","photoUrl":"https:\/\/lh3.googleusercontent.com\/-nsyfrj0LkpI\/AAAAAAAAAAI\/AAAAAAAAAAA\/AMZuucnuFKHgjCZOG6MquIJZGOafJQx2eA\/s96-c\/photo.jpg","dateLastActive":"2021-02-03T19:04:35+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-07-11T19:26:26+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\/75681\/why-am-i-getting-a-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75681\/why-am-i-getting-a-error","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/IJFJQEBTUN3Y\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-02-03T16:19:19+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":true,"noCheckboxes":false}">

Help Article Resources