这个公式有什么问题?
标签:
答案
-
她名叫Stara ✭✭✭✭✭✭我希望你一切安好!
你好像少了一个花括号。
试试这个。
= COUNTIFS({表-销售管道范围1}，(电子邮件保护)， {OD&I管道跟踪器范围}，"管道")那有用吗?
我希望这能有所帮助!
注意安全，祝你周末愉快!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请通过以下方式支持社区将其标记为有见地/投票赞成或/和作为可接受的答案．这将使别人更容易找到解决方案或帮助回答!
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时联系我有关Smartsheet的帮助，集成，一般的工作流程建议，或其他完全的东西。
-
菲尔·怀特曼 ✭✭✭✭✭✭我在OD&I管道跟踪器范围后添加了花括号，但仍然不工作。嗯。
-
她名叫Stara ✭✭✭✭✭✭
还是同样的错误信息吗?
你检查过范围了吗?
-
我很乐意帮你看一眼。
你能更详细地描述一下你的过程吗共享表格/表格副本还是一些截图?(在分享之前删除/替换任何机密/敏感信息)这会让你更容易提供帮助。(分享,(电子邮件保护)）
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时联系我有关Smartsheet的帮助，集成，一般的工作流程建议，或其他完全的东西。
帮助文章资源欧宝体育app官方888
类别
=iferror(<\/strong>INDEX({picked up}, MATCH([Ticket #]@row, {ticket number}, 0)),\"//www.santa-greenland.com/community/discussion/91574/\"<\/strong><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-01 10:34:29","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-11-01T13:40:41+00:00","banned":0,"punished":0,"private":false,"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":97144,"type":"question","name":"Formula for CountIf One column has a value and another column is not blank","excerpt":"Hello, I'm reaching out to the community for help with creating two separate sheet summary formulas (see example in image below), to: Count the \"red\" values in the \"ryg\" column ONLY IF the \"New Target Finish\" column value is NOT blank Count the number of blank cells in the \"New Target Finish\" column Thank you, in advance,…","categoryID":322,"dateInserted":"2022-10-29T19:24:49+00:00","dateUpdated":null,"dateLastComment":"2022-10-30T16:29:14+00:00","insertUserID":119439,"insertUser":{"userID":119439,"name":"Lisa Matthews","url":"https:\/\/community.smartsheet.com\/profile\/Lisa%20Matthews","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!GlFVn_Nz2Xw!wlDUP2yDueY!ag-sVUwuD_X","dateLastActive":"2022-10-30T16:28:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":119439,"lastUser":{"userID":119439,"name":"Lisa Matthews","url":"https:\/\/community.smartsheet.com\/profile\/Lisa%20Matthews","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!GlFVn_Nz2Xw!wlDUP2yDueY!ag-sVUwuD_X","dateLastActive":"2022-10-30T16:28:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":40,"score":null,"hot":3334220043,"url":"https:\/\/community.smartsheet.com\/discussion\/97144\/formula-for-countif-one-column-has-a-value-and-another-column-is-not-blank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97144\/formula-for-countif-one-column-has-a-value-and-another-column-is-not-blank","format":"Rich","lastPost":{"discussionID":97144,"commentID":349248,"name":"Re: Formula for CountIf One column has a value and another column is not blank","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/349248#Comment_349248","dateInserted":"2022-10-30T16:29:14+00:00","insertUserID":119439,"insertUser":{"userID":119439,"name":"Lisa Matthews","url":"https:\/\/community.smartsheet.com\/profile\/Lisa%20Matthews","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!GlFVn_Nz2Xw!wlDUP2yDueY!ag-sVUwuD_X","dateLastActive":"2022-10-30T16:28:16+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\/JRDU9OP3X739\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-30T16:28:13+00:00","dateAnswered":"2022-10-30T13:13:03+00:00","acceptedAnswers":[{"commentID":349240,"body":"
