汇总表公式计数:未来60天
最佳答案
-
杰夫瑞斯曼 ✭✭✭✭✭哪一个是准确的?也许过滤器中的“过去(天)”部分包含了今天的日期，使其有效地成为today (-59)?为了验证这一点，去掉>=TODAY(-60)的等号，看看是否得到4的计数。
0
答案
-
Kaleb ✭我调整了过去60天的公式，过滤结果是4:
公式结果为0。我所做的唯一改变是将状态改为完成，使用完成日期实际列，并翻转小于60的符号，但结果是0。
我挠头了，因为它应该是相同的逻辑，但少于60天。
0 -
杰夫瑞斯曼 ✭✭✭✭✭
你必须切换到>= TODAY(-60)和< TODAY(0)。您需要在这里使用-60(-60)来指定过去的60天。
=COUNTIFS(Status:Status， "2-In Process"，[完成日期(计划)]:[完成日期(计划)]，>= TODAY(-60)，[完成日期(计划)]:[完成日期(计划)]，< TODAY(0)))
0 -
杰夫瑞斯曼 ✭✭✭✭✭
哪一个是准确的?也许过滤器中的“过去(天)”部分包含了今天的日期，使其有效地成为today (-59)?为了验证这一点，去掉>=TODAY(-60)的等号，看看是否得到4的计数。
0
帮助文章资源欧宝体育app官方888
类别
Try this:<\/p>
=AVG(COLLECT({Source 1}, {Source 2}, \"Closed\", {Source 3}, >=DATE(2021, 1, 1), {Source 3}, <=DATE(2021, 3, 31)))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-30 20:52:39","updateUser":{"userID":150538,"name":"Preston P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Preston%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nWVKDFTEFOKBN.png","dateLastActive":"2022-09-30T21:01:47+00:00","banned":0,"punished":0,"private":true,"label":"Employee Admin"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":96105,"type":"question","name":"Sheet Summary formula to pull value of cell based on latest date","excerpt":"Hello Community - I've scoured the forum and can't find a solution for my particular situation. I have a sheet where I want a summary field to pull in the value in the CL Readmit VAR column based on the most recent date in the Modified column. The sheet will continue to populate rows from a form so I need the summary field…","categoryID":322,"dateInserted":"2022-09-30T16:05:58+00:00","dateUpdated":null,"dateLastComment":"2022-09-30T17:25:16+00:00","insertUserID":94581,"insertUser":{"userID":94581,"name":"Nate H","url":"https:\/\/community.smartsheet.com\/profile\/Nate%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zclY8_Wr1To!ZNlVWfX5Z7o!6eTqb2RjeNf","dateLastActive":"2022-09-30T17:42:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":94581,"lastUser":{"userID":94581,"name":"Nate H","url":"https:\/\/community.smartsheet.com\/profile\/Nate%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zclY8_Wr1To!ZNlVWfX5Z7o!6eTqb2RjeNf","dateLastActive":"2022-09-30T17:42:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":33,"score":null,"hot":3329115074,"url":"https:\/\/community.smartsheet.com\/discussion\/96105\/sheet-summary-formula-to-pull-value-of-cell-based-on-latest-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96105\/sheet-summary-formula-to-pull-value-of-cell-based-on-latest-date","format":"Rich","lastPost":{"discussionID":96105,"commentID":345549,"name":"Re: Sheet Summary formula to pull value of cell based on latest date","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/345549#Comment_345549","dateInserted":"2022-09-30T17:25:16+00:00","insertUserID":94581,"insertUser":{"userID":94581,"name":"Nate H","url":"https:\/\/community.smartsheet.com\/profile\/Nate%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zclY8_Wr1To!ZNlVWfX5Z7o!6eTqb2RjeNf","dateLastActive":"2022-09-30T17:42:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/AK09Q0Y55U3I\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-30T17:25:24+00:00","dateAnswered":"2022-09-30T16:45:03+00:00","acceptedAnswers":[{"commentID":345536,"body":"
Products Company\n----------------------\nProduct 1 Company 1\nProduct 2 Company 2\nProduct 3 Company 1\nProduct 4 Company 2\nProduct 5 Company 5\n<\/pre>Now in your original sheet use the formula: <\/p>
=VLOOKUP(Product@row, {Product to Company Range 1}, 2, false)\n<\/pre>Notes: <\/p>
- {Product to Company Range 1} is a \"Reference\" to the second sheet that needs to be created. <\/li>
- see the VLOOKUP documents for more details https:\/\/help.smartsheet.com\/function\/vlookup<\/a><\/li><\/ul>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-30 17:42:00","updateUser":{"userID":153039,"name":"tmckivergan","url":"https:\/\/community.smartsheet.com\/profile\/tmckivergan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-30T17:39:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
