计数基于两个标准
你好,
这只是下面的一个例子。我试图得到一个公式的“计数”列。我想从“日期”和“组”返回一个数字。如果在同一组中有两个相同的日期,我希望在该单元格中有一个'2'。如果该组只有一个日期,我希望在该单元格中有一个'1'。明白了吗?
蒂雅
最佳答案
-
吉纳维芙P。 员工管理
@row是一个需要以小写输入的函数。试一试:
= countifs([分娩日期]:[分娩日期],[分娩日期]@row, compound:复合的,复合的@row)
干杯!
吉纳维芙
答案
-
杰夫瑞斯曼 ✭✭✭✭✭✭
问候,
杰夫瑞斯曼,IT业务分析师及项目协调员,三菱电机特灵美国
链接:智能表功能帮助页面链接:Smartsheet公式错误信息
如果我的回答帮助解决了您的问题,请将其标记为接受,以便其他用户稍后可以找到它。谢谢!
-
JJMunoz ✭
谢谢-我试过了,#不可解析#出现了。
-
吉纳维芙P。 员工管理
在Jeff的示例中,列名需要与您的列名相同。你的屏幕截图有文本“日期”和“组”在一个单元格中,所以公式是:
=条件统计(日期:日期,(电子邮件保护)组:集团(电子邮件保护))
但是,如果存放日期的列实际上被称为“开始日期”,那么您需要将其更新为:
=条件统计([开始日期]:[开始日期],[开始日期]组:集团@row(电子邮件保护))
明白了吗?下面是一篇介绍公式中引用列的文章:在公式中创建单元格或列引用
如果这没有帮助,那么查看实际表的屏幕截图会很有用,其中包括列名和识别列类型,但请屏蔽敏感数据。
欢呼,
吉纳维芙
-
杰夫瑞斯曼 ✭✭✭✭✭✭
谢谢你的介入,吉纳维芙。
@JJMunoz它总是有助于提供列名,数据布局等截屏,包括任何公式,你已经尝试和结果的错误消息。有了这些信息,大多数时候其他用户或社区中的真正专家可以很快地为您指出正确的方向。
问候,
杰夫瑞斯曼,IT业务分析师及项目协调员,三菱电机特灵美国
链接:智能表功能帮助页面链接:Smartsheet公式错误信息
如果我的回答帮助解决了您的问题,请将其标记为接受,以便其他用户稍后可以找到它。谢谢!
-
JJMunoz ✭
@Jeff瑞斯曼@Genevieve P。谢谢你们两位。还有什么问题?
这是一个截图。这是单元格中的当前公式。
= countifs([分娩日期]:[分娩日期],[分娩日期]@row, compound: compound,(电子邮件保护))
-
吉纳维芙P。 员工管理
@row是一个需要以小写输入的函数。试一试:
= countifs([分娩日期]:[分娩日期],[分娩日期]@row, compound:复合的,复合的@row)
干杯!
吉纳维芙
-
JJMunoz ✭
@Genevieve P。就是这样!谢谢你!我是新手,所以我很感谢你的帮助!
-
吉纳维芙P。 员工管理
没问题!在某种程度上,我们都是新手
这就是社区的伟大之处——有很多很棒的智能手机用户喜欢@Jeff瑞斯曼谁可以帮助回答问题!
我还推荐内容大学如果你的计划有访问它,并且免费新员工培训在线研讨会,在这里。
欢呼,
吉纳维芙
-
杰夫瑞斯曼 ✭✭✭✭✭✭
下面我签名中的两个链接指向函数列表(链接到所有的帮助页面)和公式错误信息列表。两者都是使用Smartsheet公式的宝欧宝体育app官方888贵资源,我几乎每天都在使用它们。
在解决方案中心可以找到另一个非常有用的资源。搜索“公式示例”,你会找到一个模板,你可以添加到你的Smartsheet文件夹。此模板包含所有函数的真实示例,超出了您在函数帮助页面上获得的内容。
问候,
杰夫瑞斯曼,IT业务分析师及项目协调员,三菱电机特灵美国
链接:智能表功能帮助页面链接:Smartsheet公式错误信息
如果我的回答帮助解决了您的问题,请将其标记为接受,以便其他用户稍后可以找到它。谢谢!
帮助文章参考资料欧宝体育app官方888
类别
I hope you're well and safe!<\/p>
Unfortunately, it's not possible now, but it's an excellent idea!<\/p>
Please submit this as a Product Feedback or Idea <\/strong>(If it hasn't been added already)<\/em><\/strong> when you have a moment.<\/strong><\/a><\/p> Here's a possible workaround or workarounds <\/strong><\/p> Would that work\/help? <\/p> I hope that helps!<\/p> Be safe, and have a fantastic week!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":106637,"type":"question","name":"How can I sum cells that include the abbreviation of states, but include commas in between?","excerpt":"As of right now I am summing selected cells, which then gives me everything that is in those cells. It is then merging them together, but I need it to include a comma if there is more than 1 cell that has information in it.","categoryID":322,"dateInserted":"2023-06-20T14:46:57+00:00","dateUpdated":null,"dateLastComment":"2023-06-20T15:31:02+00:00","insertUserID":151023,"insertUser":{"userID":151023,"name":"haley brianne","title":"","url":"https:\/\/community.smartsheet.com\/profile\/haley%20brianne","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nW1W8KHNFR845.png","dateLastActive":"2023-06-20T15:21:53+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-20T18:40:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":39,"score":null,"hot":3374551679,"url":"https:\/\/community.smartsheet.com\/discussion\/106637\/how-can-i-sum-cells-that-include-the-abbreviation-of-states-but-include-commas-in-between","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106637\/how-can-i-sum-cells-that-include-the-abbreviation-of-states-but-include-commas-in-between","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106637,"commentID":381333,"name":"Re: How can I sum cells that include the abbreviation of states, but include commas in between?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381333#Comment_381333","dateInserted":"2023-06-20T15:31:02+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-20T18:40:04+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\/0Z0RK4QSFIJG\/screenshot-2023-06-20-at-9-45-30-am.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-06-20 at 9.45.30 AM.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-20T15:22:33+00:00","dateAnswered":"2023-06-20T15:11:00+00:00","acceptedAnswers":[{"commentID":381325,"body":" Try this instead:<\/p> =JOIN(COLLECT([Dash Columns]12:[Dash Columns]61, [Dash Columns]12:[Dash Columns]61, @cell <> \"//www.santa-greenland.com/community/discussion/comment/328127/\"), \", \")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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"}]},{"discussionID":106627,"type":"question","name":"Automated due date for every Monday","excerpt":"I have several reports that I run. I have a SmartSheet that lists how often it runs (Daily, weekly or monthly). I have an equation that calculates the next due date based on the completion date. The completion date is automatically recorded when I complete the report. It works beautifully except for the times that weekly…","categoryID":322,"dateInserted":"2023-06-20T12:08:03+00:00","dateUpdated":null,"dateLastComment":"2023-06-20T13:15:59+00:00","insertUserID":120783,"insertUser":{"userID":120783,"name":"Lisa Vercellone","url":"https:\/\/community.smartsheet.com\/profile\/Lisa%20Vercellone","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-20T16:08:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":120783,"lastUser":{"userID":120783,"name":"Lisa Vercellone","url":"https:\/\/community.smartsheet.com\/profile\/Lisa%20Vercellone","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-20T16:08:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":25,"score":null,"hot":3374531042,"url":"https:\/\/community.smartsheet.com\/discussion\/106627\/automated-due-date-for-every-monday","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106627\/automated-due-date-for-every-monday","format":"Rich","lastPost":{"discussionID":106627,"commentID":381284,"name":"Re: Automated due date for every Monday","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381284#Comment_381284","dateInserted":"2023-06-20T13:15:59+00:00","insertUserID":120783,"insertUser":{"userID":120783,"name":"Lisa Vercellone","url":"https:\/\/community.smartsheet.com\/profile\/Lisa%20Vercellone","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-20T16:08:37+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\/7LJZYGRS3588\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-20T13:17:21+00:00","dateAnswered":"2023-06-20T12:22:38+00:00","acceptedAnswers":[{"commentID":381263,"body":" Incorporate the below into your formula it will give you the Monday following the last completed date.<\/p> =[Completed Date]@row - (WEEKDAY([Completed Date]@row) - 2)+7<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">