基于另一列计算行数
我有一张这样的单子:
个案编号|输入日期|个案/天
我想计算每个日期输入的案例数。我假设我会使用COUNTIF公式,但我不确定如何告诉它计算每个日期的情况,而不是如果日期=某个值。
谢谢!
最佳答案
-
基督教伯爵 ✭✭✭✭✭
好吧,
如果你把下面的公式放在case /day这一栏,并使它成为一个列式公式,它应该可以工作。
=COUNTIF([扫描日期]:[扫描日期],=[扫描日期]@row)
答案
-
基督教伯爵 ✭✭✭✭✭
所以您正在尝试填充案例/日列?你能分享一张床单的图片吗?不清楚你想做什么。
像这样的?
=SUMIFS([Case Number]:[Case Number], [Date Entered]:[Date Entered], (Date Entered)@row)
-
jhorvath ✭
@Christian伯爵这是我正在研究的东西:
在我看来,专栏可能不是最好的方式。但是我需要对每个日期的行数求和,所以在这个例子中我有两个日期。我需要收集的数据显示2/23/22有7例,3/3/22有4例。
-
基督教伯爵 ✭✭✭✭✭
好吧,
如果你把下面的公式放在case /day这一栏,并使它成为一个列式公式,它应该可以工作。
=COUNTIF([扫描日期]:[扫描日期],=[扫描日期]@row)
类别
You are welcome. One Day the platform will allow this but for now we wait. If my answer was sufficient please mark your question as answered.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]},{"discussionID":105945,"type":"question","name":"Dashboard reports not showing on published dashboard in SharePoint","excerpt":"I have embedded a Smartsheet dashboard in a SharePoint Online site. Some reports show just fine, two do not and I can't figure out why. I published the dashboard and grabbed the embed code. Used an embed web part in SharePoint to embed the dashboard. Two reports show fine, the other two have errors. There is nothing…","categoryID":321,"dateInserted":"2023-06-02T12:17:45+00:00","dateUpdated":null,"dateLastComment":"2023-06-02T12:33:24+00:00","insertUserID":81546,"insertUser":{"userID":81546,"name":"Andrea Zenner","url":"https:\/\/community.smartsheet.com\/profile\/Andrea%20Zenner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-03\/c8\/bb\/nc8bb6b7bd2a9297545e5baeb6a5ba8ed.jpg","dateLastActive":"2023-06-02T12:33:56+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-06-02T20:54:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":34,"score":null,"hot":3371419869,"url":"https:\/\/community.smartsheet.com\/discussion\/105945\/dashboard-reports-not-showing-on-published-dashboard-in-sharepoint","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105945\/dashboard-reports-not-showing-on-published-dashboard-in-sharepoint","format":"Rich","tagIDs":[265,292],"lastPost":{"discussionID":105945,"commentID":378523,"name":"Re: Dashboard reports not showing on published dashboard in SharePoint","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378523#Comment_378523","dateInserted":"2023-06-02T12:33:24+00:00","insertUserID":45516,"insertUser":{"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-06-02T20:54:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/PF6NIRYD5DHX\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-02T12:34:10+00:00","dateAnswered":"2023-06-02T12:33:24+00:00","acceptedAnswers":[{"commentID":378523,"body":"
That is exactly it. Is the \"Their Own Perspective\" the broken one? Basically... You have to be logged in to Smartsheet for Smartsheet to know who is viewing the report so that it can provide the correct \"perspective\".<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":265,"urlcode":"Reports","name":"Reports"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">