公式

1,…","categoryID":322,"dateInserted":"2023-01-25T23:02:08+00:00","dateUpdated":null,"dateLastComment":"2023-01-30T10:00:49+00:00","insertUserID":143257,"insertUser":{"userID":143257,"name":"Bobby1","url":"https:\/\/community.smartsheet.com\/profile\/Bobby1","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-03T10:08:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"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-03T17:38:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":32,"score":null,"hot":3349763577,"url":"https:\/\/community.smartsheet.com\/discussion\/100188\/combine-formula-to-look-up-2-diff-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100188\/combine-formula-to-look-up-2-diff-sheets","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/4VT8BD3BQZ46\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-01-26T20:49:27+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":100332,"type":"question","name":"RYG ball to determine priority involving multiple dates","excerpt":"I have a sheet that lists all active contracts for my department which all have expiration dates. However, I am struggling with this sheet because in all calculations I need to consider any extension dates. I do fine with calculations when there is one date involved but when I need to write them to incorporate two and…","categoryID":322,"dateInserted":"2023-01-28T18:40:15+00:00","dateUpdated":null,"dateLastComment":"2023-01-29T22:57:58+00:00","insertUserID":157391,"insertUser":{"userID":157391,"name":"Linda Armstrong","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Linda%20Armstrong","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp5oh3DbS-eiYJ9XPwhfnQpCXSuv9jRcYs7N-jSa=s96-c","dateLastActive":"2023-02-03T19:58:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":112221,"lastUser":{"userID":112221,"name":"Kelly Moore","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2023-02-03T22:46:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":33,"score":null,"hot":3349966093,"url":"https:\/\/community.smartsheet.com\/discussion\/100332\/ryg-ball-to-determine-priority-involving-multiple-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100332\/ryg-ball-to-determine-priority-involving-multiple-dates","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/7HY0BAMWN4Q0\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-29T22:49:51+00:00","dateAnswered":"2023-01-29T21:56: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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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":100318,"type":"question","name":"combining vlookup with sum formulas","excerpt":"Hello Everyone, I am stumped again like usual and looking of help with getting a formula right. I am creating a data analysis sheet to generate sums and averages based on another sheet which has raw data. I understand how to do a sumif formula and separately how to write a vlookup formula, but I am struggling to combine…","categoryID":322,"dateInserted":"2023-01-27T22:05:45+00:00","dateUpdated":null,"dateLastComment":"2023-01-28T00:07:01+00:00","insertUserID":147546,"insertUser":{"userID":147546,"name":"Nick Amsler","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Amsler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-28T00:04:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":147546,"lastUser":{"userID":147546,"name":"Nick Amsler","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Amsler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-28T00:04:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":33,"score":null,"hot":3349722766,"url":"https:\/\/community.smartsheet.com\/discussion\/100318\/combining-vlookup-with-sum-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100318\/combining-vlookup-with-sum-formulas","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/GZ5PIUMMHH3D\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-28T00:04:39+00:00","dateAnswered":"2023-01-27T23:07:58+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":100289,"type":"question","name":"Using COUNTIFS With Contacts, CONTAINS, and OR","excerpt":"I'm essentially trying to make a sheet summary formula for how many open cases someone in a contact list has at the moment. I've got it working when I'm looking at the contact list one way, but the users of this sheet have a bad habit of entering data so that their email address displays in the contact list rather than…","categoryID":322,"dateInserted":"2023-01-27T17:10:23+00:00","dateUpdated":null,"dateLastComment":"2023-01-27T23:19:12+00:00","insertUserID":154667,"insertUser":{"userID":154667,"name":"robinw","url":"https:\/\/community.smartsheet.com\/profile\/robinw","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-30T14:11:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","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-02-03T21:25:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":12,"score":null,"hot":3349702175,"url":"https:\/\/community.smartsheet.com\/discussion\/100289\/using-countifs-with-contacts-contains-and-or","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100289\/using-countifs-with-contacts-contains-and-or","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-01-27T18:06:52+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":281,"urlcode":"Support","name":"Support"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"}],"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":62171,"type":"discussion","name":"Formula help for previous month","excerpt":"I have a helper column for a report that I want to check the box if the DATE cell is in the previous month. Any help is appreciated!!","categoryID":322,"dateInserted":"2019-11-06T11:31:42+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-01-27T23:04:07+00:00","insertUserID":62371,"insertUser":{"userID":62371,"name":"Ryan Murphy","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Murphy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bslXG6WxXTo!bMdX21WFTTo!eH6YuKLwTTd","dateLastActive":"2023-01-10T19:48:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":122906,"lastUser":{"userID":122906,"name":"Cesar Perez","url":"https:\/\/community.smartsheet.com\/profile\/Cesar%20Perez","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2uFV_3dM1no!ndnWXxsFlTw!JCwGNa_KQWy","dateLastActive":"2023-02-03T17:07:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":483,"score":null,"hot":3247905949,"url":"https:\/\/community.smartsheet.com\/discussion\/62171\/formula-help-for-previous-month","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/62171\/formula-help-for-previous-month","format":"Html","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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":281,"urlcode":"Support","name":"Support"}],"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":100313,"type":"question","name":"Sum(Children()) and Sum(row:row) not totaling correctly","excerpt":"I created a sheet to itemize costs on furniture orders. I used a hierarchy so I could just use =sum(children()) to see the total costs of each project. While the first project totaled correctly, the second is coming up with an additional $2919.36. First I went back to ensure all of the figures are correct, and they are. I…","categoryID":322,"dateInserted":"2023-01-27T21:19:58+00:00","dateUpdated":null,"dateLastComment":"2023-01-27T22:14:51+00:00","insertUserID":157508,"insertUser":{"userID":157508,"name":"Michelle Simonson","url":"https:\/\/community.smartsheet.com\/profile\/Michelle%20Simonson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zKFrM9Yxz_o!pXcr6dILqro!pGdYCA9NAX9","dateLastActive":"2023-02-03T00:18:13+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-02-03T18:28:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":34,"score":null,"hot":3349715089,"url":"https:\/\/community.smartsheet.com\/discussion\/100313\/sum-children-and-sum-row-row-not-totaling-correctly","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100313\/sum-children-and-sum-row-row-not-totaling-correctly","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/7JO6L97CVV2I\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-27T22:15:35+00:00","dateAnswered":"2023-01-27T21:59: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":[{"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":100139,"type":"question","name":"How to use the COUNTIF formula when you have an OR statement that looks at multiple columns","excerpt":"I am trying to come up with a formula that will calculate how many tasks I have that are either \"At Risk\", which is a checkbox (flag) column, or has red health, which is a symbol column. I need a formula that does not add the totals of those conditions. For example, if a task is both At Risk and red health, I want that to…","categoryID":322,"dateInserted":"2023-01-25T15:09:07+00:00","dateUpdated":null,"dateLastComment":"2023-01-27T21:31:01+00:00","insertUserID":147967,"insertUser":{"userID":147967,"name":"WilliamPaschall","url":"https:\/\/community.smartsheet.com\/profile\/WilliamPaschall","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ofHYKF0Gjv0!3-dZ_9Xa_j0!vXdT5UjXT2h","dateLastActive":"2023-01-27T21:28: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-02-03T18:28:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":12,"score":null,"hot":3349516208,"url":"https:\/\/community.smartsheet.com\/discussion\/100139\/how-to-use-the-countif-formula-when-you-have-an-or-statement-that-looks-at-multiple-columns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100139\/how-to-use-the-countif-formula-when-you-have-an-or-statement-that-looks-at-multiple-columns","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-27T21:29:00+00:00","dateAnswered":"2023-01-25T20:04: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":100151,"type":"question","name":"Receiving INCORRECT ARGUMENT SET when using an IFERROR","excerpt":"This is the error I'm receiving on my sheet summary page. Please note that the sheet is \"set up\" with columns and necessary formulas, there is just no information entered yet. Every time I open this sheet, I get the error above. To fix this problem, I just copy the formula, delete it, then re-paste it. This is after I…","categoryID":322,"dateInserted":"2023-01-25T17:06:46+00:00","dateUpdated":"2023-01-25T19:38:19+00:00","dateLastComment":"2023-01-27T21:13:01+00:00","insertUserID":155918,"insertUser":{"userID":155918,"name":"Gabriel Barrera","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Gabriel%20Barrera","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-01T17:53:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":155918,"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-02-03T18:28:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":56,"score":null,"hot":3349524587,"url":"https:\/\/community.smartsheet.com\/discussion\/100151\/receiving-incorrect-argument-set-when-using-an-iferror","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100151\/receiving-incorrect-argument-set-when-using-an-iferror","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/O1K8J7XUAKU7\/incorret-argument-set-smartsheet-question.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"incorret_argument_set_smartsheet_question.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-26T12:14:23+00:00","dateAnswered":"2023-01-25T20:19: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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":335,"urlcode":"sheet-summary","name":"Sheet Summary"}],"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":100286,"type":"question","name":"Adding a Date require to IF statement","excerpt":"Hello, I'm looking for assistance in adding some criteria to this AVERAGEIF formula to make it so I am only averaging dates from this year. =AVERAGEIF({Completed - Department}, =[30 Day Post Release Quality Score - Segments]@row, {Completed - AQualityP30D}) There is no AVGIFS so I'm not sure how to appraoch this any…","categoryID":322,"dateInserted":"2023-01-27T16:57:41+00:00","dateUpdated":null,"dateLastComment":"2023-01-27T17:58:54+00:00","insertUserID":144713,"insertUser":{"userID":144713,"name":"Dakota Haeffner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Dakota%20Haeffner","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-9EoN6cCJXs!7Dcqe8-aSLs!vmL02Fkj5JV","dateLastActive":"2023-02-02T15:20:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","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-02-03T21:25:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":3349681595,"url":"https:\/\/community.smartsheet.com\/discussion\/100286\/adding-a-date-require-to-if-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100286\/adding-a-date-require-to-if-statement","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-27T18:56:00+00:00","dateAnswered":"2023-01-27T17:58:54+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":84458,"type":"question","name":"Need to add 6 months and 3 months to a date","excerpt":"I have a date that other will populate, but I need to have two columns that calculated 3 months out from the date and 6 months out. I have tried several formulas on the forum and nothing is working. I am completely stumped. If I was in excel this would have been done in a minute.","categoryID":322,"dateInserted":"2021-10-27T18:02:40+00:00","dateUpdated":null,"dateLastComment":"2023-01-27T16:42:14+00:00","insertUserID":141278,"insertUser":{"userID":141278,"name":"Vanessa K","url":"https:\/\/community.smartsheet.com\/profile\/Vanessa%20K","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-10-28T21:11:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":157289,"lastUser":{"userID":157289,"name":"Deanna DeCoursey","url":"https:\/\/community.smartsheet.com\/profile\/Deanna%20DeCoursey","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uwkmJx_Cnqs!gitnn7OsuPs!7-viQBH34DZ","dateLastActive":"2023-01-27T16:11:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":35,"countViews":478,"score":null,"hot":3310216494,"url":"https:\/\/community.smartsheet.com\/discussion\/84458\/need-to-add-6-months-and-3-months-to-a-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/84458\/need-to-add-6-months-and-3-months-to-a-date","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/XFN0LSXYW4SV\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-27T15:20:00+00:00","dateAnswered":"2023-01-27T14:15:08+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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">