Formulas and Functions

= 14,…","categoryID":322,"dateInserted":"2020-06-10T00:25:17+00:00","dateUpdated":null,"dateLastComment":"2020-06-16T19:54:24+00:00","insertUserID":82916,"insertUser":{"userID":82916,"name":"cdh8331","url":"https:\/\/community.smartsheet.com\/profile\/cdh8331","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-08-11T19:20: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-07-14T18:58:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":396,"score":null,"hot":10,"url":"https:\/\/community.smartsheet.com\/discussion\/69000\/more-than-2-logical-expressions-for-or-function","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69000\/more-than-2-logical-expressions-for-or-function","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-06-10T18:11:16+00:00","dateAnswered":"2020-06-10T12:43:48+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":69173,"type":"question","name":"create list based on a word","excerpt":"We have a contractor list that captures our contractors data from a form on our website. Here is the web address if you would like to take a look: https:\/\/app.smartsheet.com\/b\/form\/e69cfae30cc14c0ebc35f351bf9129a5 One of the cool features of this list is that it utilizes a multi-select dropdown menu. The challenge is…","categoryID":322,"dateInserted":"2020-06-16T17:54:18+00:00","dateUpdated":null,"dateLastComment":"2020-06-16T19:42:53+00:00","insertUserID":66946,"insertUser":{"userID":66946,"name":"MMerin","title":"Contract & Procurement Specialist","url":"https:\/\/community.smartsheet.com\/profile\/MMerin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/FCSSAOLJCO1O\/n540PBK9RMHN2.png","dateLastActive":"2023-06-28T00:08:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":66946,"lastUser":{"userID":66946,"name":"MMerin","title":"Contract & Procurement Specialist","url":"https:\/\/community.smartsheet.com\/profile\/MMerin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/FCSSAOLJCO1O\/n540PBK9RMHN2.png","dateLastActive":"2023-06-28T00:08:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":74,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/69173\/create-list-based-on-a-word","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69173\/create-list-based-on-a-word","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-05-18T23:20:21+00:00","dateAnswered":"2020-06-16T19:38:51+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":69131,"type":"question","name":"Formula for Counting RYG by Child Row","excerpt":"Hello - I'm trying to add to a Dashboard. I need to see status by color for each child row. I also need a count by each child row (Admin, CPM, etc.). Help! Thank you.","categoryID":322,"dateInserted":"2020-06-15T19:31:37+00:00","dateUpdated":null,"dateLastComment":"2020-06-16T18:13:15+00:00","insertUserID":122661,"insertUser":{"userID":122661,"name":"Staci Britton","url":"https:\/\/community.smartsheet.com\/profile\/Staci%20Britton","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!g5FYp_XTA3o!xtFZcSWN_fo!dI3ou1er1eo","dateLastActive":"2022-03-01T18:03:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":16866,"lastUser":{"userID":16866,"name":"L_123","title":"","url":"https:\/\/community.smartsheet.com\/profile\/L_123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-12T15:32:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":213,"score":null,"hot":10,"url":"https:\/\/community.smartsheet.com\/discussion\/69131\/formula-for-counting-ryg-by-child-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69131\/formula-for-counting-ryg-by-child-row","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/XGANH0UWKGUC\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-06-16T15:45:44+00:00","dateAnswered":"2020-06-16T15:14:49+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"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":69147,"type":"question","name":"SUMIFS help in Summary with column headers containing special chars","excerpt":"I'm trying to get the below SUMIFS to work but i'm getting #UNPARSEABLE. =SUMIFS(Requested Amount (in Local Currency):Requested Amount (in Local Currency), Budget Owner*:Budget Owner*, \"Tom MacKay\", Approved:Approved, = 1) The column names contain special characters, is that what is causing the problem? Or do I just have…","categoryID":322,"dateInserted":"2020-06-16T03:17:32+00:00","dateUpdated":null,"dateLastComment":"2020-06-16T16:51:10+00:00","insertUserID":76986,"insertUser":{"userID":76986,"name":"garcias76986","url":"https:\/\/community.smartsheet.com\/profile\/garcias76986","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-01\/f9\/9e\/nf99e7e3700db437707e45f45b7db83b5.jpg","dateLastActive":"2021-04-08T23:07:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":76986,"lastUser":{"userID":76986,"name":"garcias76986","url":"https:\/\/community.smartsheet.com\/profile\/garcias76986","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-01\/f9\/9e\/nf99e7e3700db437707e45f45b7db83b5.jpg","dateLastActive":"2021-04-08T23:07:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":154,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/69147\/sumifs-help-in-summary-with-column-headers-containing-special-chars","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69147\/sumifs-help-in-summary-with-column-headers-containing-special-chars","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-06-16T16:50:36+00:00","dateAnswered":"2020-06-16T08:09:49+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":69134,"type":"question","name":"LOOKUP OR FIND WITH SUMUP COMBINED","excerpt":"Hello, Hope you could help me. On Sheet 1, \"Future Column\", I would like to find in Sheet 2 all similar names against sheet 1. Ex. In Sheet 1 - BOFA, BOFACBRE, BOFAJLL is on Sheet 2 all in Different rows. I would like to combine and sum up as for Sheet 1 \"Future\" is equal to 9. SHEET 1 SHEET 2","categoryID":322,"dateInserted":"2020-06-15T19:54:26+00:00","dateUpdated":null,"dateLastComment":"2020-06-16T16:46:56+00:00","insertUserID":103391,"insertUser":{"userID":103391,"name":"Marilen.Navarro103391","url":"https:\/\/community.smartsheet.com\/profile\/Marilen.Navarro103391","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-09\/60\/88\/n6088a8f5166f388fd95cfcb413bcbd0e.jpg","dateLastActive":"2023-07-03T11:26:19+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-14T18:58:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":101,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/69134\/lookup-or-find-with-sumup-combined","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69134\/lookup-or-find-with-sumup-combined","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/RDQ0FGII3DT5\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-06-15T20:37:38+00:00","dateAnswered":"2020-06-15T20:31: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":69085,"type":"question","name":"today() function affects last-modified date","excerpt":"We have a last-modified column in one of our sheets. We use it to detect when rows in the sheet have been last modified, driving discussions about the updates. In this sheet, another column displays a \"project completion date,\" which is just a manually entered date indicating the project owner's best guess as to when the…","categoryID":322,"dateInserted":"2020-06-12T16:42:28+00:00","dateUpdated":null,"dateLastComment":"2020-06-16T16:13:51+00:00","insertUserID":122591,"insertUser":{"userID":122591,"name":"Charlton Rose","url":"https:\/\/community.smartsheet.com\/profile\/Charlton%20Rose","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-06-16T15:12:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":121887,"lastUser":{"userID":121887,"name":"Werner Gerstacker","url":"https:\/\/community.smartsheet.com\/profile\/Werner%20Gerstacker","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GhyEvFDTdJbWSU-3MldZtUntUWWhxx41cCi2SvV","dateLastActive":"2020-11-16T19:25:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":641,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/69085\/today-function-affects-last-modified-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69085\/today-function-affects-last-modified-date","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":69152,"type":"question","name":"Why do I get #Invalid Data Type error message because a cell is blank","excerpt":"HI, I have a column that uses the formula =WORKDAY([HOP Submit F\/C]@row, 5) to give a date by which approval needs to be given for documents that have been submitted. The column [HOP Submit F\/C] is a date column which itself uses a formula '=[????? Eqpt Order ACK]@row + 145' to get its own date (the question marks…","categoryID":322,"dateInserted":"2020-06-16T10:26:03+00:00","dateUpdated":null,"dateLastComment":"2020-06-16T13:38:26+00:00","insertUserID":117196,"insertUser":{"userID":117196,"name":"Steve Bertram","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Steve%20Bertram","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-04-13T16:21:04+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-14T18:58:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":261,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/69152\/why-do-i-get-invalid-data-type-error-message-because-a-cell-is-blank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69152\/why-do-i-get-invalid-data-type-error-message-because-a-cell-is-blank","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-06-16T13:35:38+00:00","dateAnswered":"2020-06-16T12:56:48+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":69149,"type":"question","name":"Average IF Within 30 days","excerpt":"Hello, I am trying to figure out a formula to average a particular column of information, but only within the last 30 days. I have a \"Todays Date\" Formula\/column already created, but not sure how to write the formula to be able to read my whole column of data but only pull from the past 30 days. I appreciate any help in…","categoryID":322,"dateInserted":"2020-06-16T04:51:16+00:00","dateUpdated":null,"dateLastComment":"2020-06-16T13:35:44+00:00","insertUserID":122682,"insertUser":{"userID":122682,"name":"Julie Boss","url":"https:\/\/community.smartsheet.com\/profile\/Julie%20Boss","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GgXRvJtCbsH9jHWE-BMmk21aOO-NeZOzjyXCZEFPQ","dateLastActive":"2020-06-30T20:41:32+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-14T18:58:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":379,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/69149\/average-if-within-30-days","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69149\/average-if-within-30-days","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-06-16T13:32:20+00:00","dateAnswered":"2020-06-16T12:56:55+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":69145,"type":"question","name":"AVERAGEIF or AVG ??????Why is this not working and how do i get it to work","excerpt":"So i basically want to calculate the average of all completed query. In the picture above there is a formula that calculates how long the task takes. If is not complete it does not have a data and the formula will show the #error above..... this i think is where i am going wrong i just dont know how to change it... Please…","categoryID":322,"dateInserted":"2020-06-16T02:36:16+00:00","dateUpdated":null,"dateLastComment":"2020-06-16T13:04:29+00:00","insertUserID":47451,"insertUser":{"userID":47451,"name":"SharonR","url":"https:\/\/community.smartsheet.com\/profile\/SharonR","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/351\/nDJO0BF72ICTY.JPG","dateLastActive":"2023-04-11T22:49:32+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-14T18:58:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":91,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/69145\/averageif-or-avg-why-is-this-not-working-and-how-do-i-get-it-to-work","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69145\/averageif-or-avg-why-is-this-not-working-and-how-do-i-get-it-to-work","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/MEKGL0MOAE81\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":69154,"type":"question","name":"IF formula for earliest date","excerpt":"Hi Community, Could anyone please help with this formula syntax? I want to capture what is the earliest date within a date range for a specific role, \"Production\" in this case. =IF(Role:Role, \"Production\", COLLECT([Actual Start]:[Actual Start], [Actual Start]:[Actual Start], MIN([Actual Start]:[Actual Start])), \"//www.santa-greenland.com/community/categories/formulas-and-functions/\") It…","categoryID":322,"dateInserted":"2020-06-16T12:10:44+00:00","dateUpdated":null,"dateLastComment":"2020-06-16T13:02:42+00:00","insertUserID":109661,"insertUser":{"userID":109661,"name":"Alessandro Terranova","url":"https:\/\/community.smartsheet.com\/profile\/Alessandro%20Terranova","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-12-18T09:32:12+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-14T18:58:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":969,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/69154\/if-formula-for-earliest-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69154\/if-formula-for-earliest-date","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-06-16T12:55:02+00:00","dateAnswered":"2020-06-16T12:52:53+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":440,"urlcode":"project-management","name":"Project Management"}],"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