欢迎来到Smartsheet论坛档案


在这个论坛的帖子不再被监控的准确性和他们的内容可能不再是最新的。如果这里有你感兴趣的讨论，你想找到(或创建)一个更最新的版本，请访问当前论坛。

2017年发布的文章

讨论表

类别

受欢迎的标签

SUM formula. I commented on another post of yours with an example to solve this.<\/p>"},{"commentID":355329,"body":"

Hey @Nkeiruka. Aguocha<\/a> <\/p>

Your formula, as written, will work assuming (1) you are typing in the exact name of your \"Task\" in between the quotes and (2) you already have your {CAR Log Range 4} as a column of month numbers.<\/p>

Depending on your real data in your Task column (from the screenshot above), you may be able to make your formula dynamic (not needing to type the Task in between the quotes) by changing your formula to:<\/p>

=COUNTIFS({CAR Log Range 2}, Task@row, {CAR Log Range 4},=6) *This assumes Range 4 is a column of Month Numbers.<\/p>

If your date range is not month numbers, try this:<\/p>

=COUNTIFS({CAR Log Range 2}, Task@row, {CAR Log Range 4}, IFERROR(MONTH(@cell),0)=6)<\/p>

This uses the MONTH() function to find the month number. The IFERROR will force the month number to zero if there are non-dates in the date range. It doesn't do anything if there isn't an error. <\/p>

*If you do need to hard code in the Task names, replace the Task@row with the actual \"Task\" (insert between the quotes)<\/p>

Will any of these work for you?<\/p>

Kelly<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-26 18:38:41","updateUser":{"userID":155716,"name":"Nkeiruka. Aguocha","url":"https:\/\/community.smartsheet.com\/profile\/Nkeiruka.%20Aguocha","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-26T21:26:18+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":[]},{"discussionID":99045,"type":"question","name":"Creating a Dashboard using Formulas","excerpt":"Hello, I'm creating a dashboard and I am trying to figure out how to add two different sections (a CAR and Task). I am looking how to add how many CAR's and how many Task were issued for each month. I do have a formula page that states how many for each but I'm not sure how to state per month to be included. Please advise!…","categoryID":321,"dateInserted":"2022-12-23T18:47:06+00:00","dateUpdated":null,"dateLastComment":"2022-12-23T19:46:14+00:00","insertUserID":155716,"insertUser":{"userID":155716,"name":"Nkeiruka. Aguocha","url":"https:\/\/community.smartsheet.com\/profile\/Nkeiruka.%20Aguocha","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-26T21:26:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":150413,"lastUser":{"userID":150413,"name":"Kleerfyre","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kleerfyre","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/P5SQACVY7KUX\/n965JGG04GC94.jpg","dateLastActive":"2022-12-23T21:04:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":39,"score":null,"hot":3343647800,"url":"https:\/\/community.smartsheet.com\/discussion\/99045\/creating-a-dashboard-using-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99045\/creating-a-dashboard-using-formulas","format":"Rich","lastPost":{"discussionID":99045,"commentID":355316,"name":"Re: Creating a Dashboard using Formulas","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/355316#Comment_355316","dateInserted":"2022-12-23T19:46:14+00:00","insertUserID":150413,"insertUser":{"userID":150413,"name":"Kleerfyre","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kleerfyre","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/P5SQACVY7KUX\/n965JGG04GC94.jpg","dateLastActive":"2022-12-23T21:04:23+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-23T19:50:46+00:00","dateAnswered":"2022-12-23T19:46:14+00:00","acceptedAnswers":[{"commentID":355316,"body":"

=SUM(Select the cells you want to sum)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-23 19:50:46","updateUser":{"userID":155716,"name":"Nkeiruka. Aguocha","url":"https:\/\/community.smartsheet.com\/profile\/Nkeiruka.%20Aguocha","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-26T21:26:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]},{"discussionID":99034,"type":"question","name":"Using COUNTIF and CONTAINS","excerpt":"I need to count the number of times a word is found in a cell. My constraint is that the cell can contain multiple words (from a dropdown) and I'm not sure the formula to use. COUNTIF works just fine if the cell only contains one word. I see a report that used both COUNTIFS and CONTAINS but I can't get it to work. The…","categoryID":322,"dateInserted":"2022-12-22T22:51:19+00:00","dateUpdated":null,"dateLastComment":"2022-12-23T00:00:48+00:00","insertUserID":120231,"insertUser":{"userID":120231,"name":"Pamela Wagner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pamela%20Wagner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-22T23:55:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":120231,"lastUser":{"userID":120231,"name":"Pamela Wagner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pamela%20Wagner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-22T23:55:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3343504327,"url":"https:\/\/community.smartsheet.com\/discussion\/99034\/using-countif-and-contains","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99034\/using-countif-and-contains","format":"Rich","lastPost":{"discussionID":99034,"commentID":355271,"name":"Re: Using COUNTIF and CONTAINS","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/355271#Comment_355271","dateInserted":"2022-12-23T00:00:48+00:00","insertUserID":120231,"insertUser":{"userID":120231,"name":"Pamela Wagner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pamela%20Wagner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-22T23:55:31+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-23T00:00:06+00:00","dateAnswered":"2022-12-22T23:30:12+00:00","acceptedAnswers":[{"commentID":355270,"body":"

@Pamela Wagner<\/a> <\/p>

Here's an example sheet and formula I made for someone else's topic once.<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

=COUNTIFS([Teams Responsible for Testing]:[Teams Responsible for Testing], CONTAINS(\"MIS\", @cell), Status:Status, <>\"Complete\")<\/p>

This is used to find \"MIS\" in the Teams Responsible for Testing column if the Status column is not \"Complete\". It's finding 4 results.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-23 00:00:06","updateUser":{"userID":120231,"name":"Pamela Wagner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pamela%20Wagner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-22T23:55:31+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":[]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">