多重嵌套帮助!
所以我有6个调查问题，回答选项是“低于预期，达到预期，超过预期”。我需要它告诉我问题1在每个区域有多少低于预期，以此类推每个回答选项和区域。
到目前为止，这个公式非常有效!
=COUNTIFS([交货时效]:[交货时效]，[交货时效]@row, Region:Region，(电子邮件保护)）
但是，它为空白响应单元格填充的数字只是Region计数，即一个区域作为默认值输入了多少次。我试过了:
=COUNTIFS([交货时效]:[交货时效]，[交货时效]@row, Region:Region，(电子邮件保护)， IF(ISBLANK([交货时效]:[交货时效]，“空白”，“非空白”))))
=COUNTIFS([交货时效]:[交货时效]，[交货时效]@row, Region:Region，(电子邮件保护)， IF(ISBLANK([交货时效性]@row)，“空白”，“非空白”))))
然而，它总是返回说不正确的参数集。我该怎么做才能让Smartsheet社区变得更好呢?
答案
-
你真是个天才!谢谢，效果很好!
-
乔恩·马克·H ✭✭✭✭✭
很高兴我能帮上忙!
帮助文章参考资料欧宝体育app官方888
类别
Hi @Louis.Smith<\/a> <\/p> Maybe try this one:<\/p> =COUNTIF(Client:Client, \"Delta\")<\/p> I hope that helps.<\/p> Matt<\/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":106091,"type":"question","name":"How to reference column name pulled from formula","excerpt":"I'm trying to pull a date from columns based on the number in the helper column. I know I can do this with nested IFs, but is there a way to change which column I'm pulling the value from? My column Start Date should be whatever the column is based on the Index. So for the first column below, since Index is 3, it should…","categoryID":322,"dateInserted":"2023-06-06T19:01:04+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T19:24:57+00:00","insertUserID":162114,"insertUser":{"userID":162114,"name":"mwat4482","url":"https:\/\/community.smartsheet.com\/profile\/mwat4482","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T19:24:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162114,"lastUser":{"userID":162114,"name":"mwat4482","url":"https:\/\/community.smartsheet.com\/profile\/mwat4482","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T19:24:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":25,"score":null,"hot":3372158761,"url":"https:\/\/community.smartsheet.com\/discussion\/106091\/how-to-reference-column-name-pulled-from-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106091\/how-to-reference-column-name-pulled-from-formula","format":"Rich","lastPost":{"discussionID":106091,"commentID":379133,"name":"Re: How to reference column name pulled from formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379133#Comment_379133","dateInserted":"2023-06-06T19:24:57+00:00","insertUserID":162114,"insertUser":{"userID":162114,"name":"mwat4482","url":"https:\/\/community.smartsheet.com\/profile\/mwat4482","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T19:24:48+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\/EITIHXA4Y0I7\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-06T19:24:45+00:00","dateAnswered":"2023-06-06T19:18:07+00:00","acceptedAnswers":[{"commentID":379128,"body":" Are you trying to use that as a dynamic cell reference? If so, that is not possible. What it looks to me like you need is something more along the lines of<\/p> =INDEX([1st Date Column]@row:[Last Date Column]@row, 1, Index@row)<\/p> You are going to need to update the column names in the formula to match what you are using in your sheet.<\/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":106087,"type":"question","name":"Conditional Formatting Based on 2 Date Columns, with or without Helper Column","excerpt":"Hi! I've scoured the Community posts, and can't find exactly what I need. I am managing a membership list and need to flag when memberships expire before or on a specific date (06\/29\/2023) so I can contact those members. I have one column with their membership expiration dates, a second column with the 06\/29\/2023 deadline,…","categoryID":322,"dateInserted":"2023-06-06T18:29:42+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T19:02:02+00:00","insertUserID":162111,"insertUser":{"userID":162111,"name":"Mlichtenstein","title":"Director","url":"https:\/\/community.smartsheet.com\/profile\/Mlichtenstein","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BtDbwegK_WQ!wlnbvxwzuT4!fyPHolHHR0X","dateLastActive":"2023-06-06T18:55:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162111,"lastUser":{"userID":162111,"name":"Mlichtenstein","title":"Director","url":"https:\/\/community.smartsheet.com\/profile\/Mlichtenstein","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BtDbwegK_WQ!wlnbvxwzuT4!fyPHolHHR0X","dateLastActive":"2023-06-06T18:55:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":48,"score":null,"hot":3372157304,"url":"https:\/\/community.smartsheet.com\/discussion\/106087\/conditional-formatting-based-on-2-date-columns-with-or-without-helper-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106087\/conditional-formatting-based-on-2-date-columns-with-or-without-helper-column","format":"Rich","tagIDs":[437],"lastPost":{"discussionID":106087,"commentID":379120,"name":"Re: Conditional Formatting Based on 2 Date Columns, with or without Helper Column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379120#Comment_379120","dateInserted":"2023-06-06T19:02:02+00:00","insertUserID":162111,"insertUser":{"userID":162111,"name":"Mlichtenstein","title":"Director","url":"https:\/\/community.smartsheet.com\/profile\/Mlichtenstein","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BtDbwegK_WQ!wlnbvxwzuT4!fyPHolHHR0X","dateLastActive":"2023-06-06T18:55: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\/JWT4M72YQK8N\/screenshot-2023-06-06-142808.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-06-06 142808.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-06T19:00:34+00:00","dateAnswered":"2023-06-06T18:52:14+00:00","acceptedAnswers":[{"commentID":379113,"body":"
<\/p>
![\"Conditional](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/DD8Q3FFV2RUK\/conditional-formating.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
