Smartsheet客户故事计划

You are essentially telling the formula to only pull numbers that are equal to \"Office Innovations\". That is definitely not a number, so there is nothing being pulled in. Try adjusting the syntax to fit the SUMIF function.<\/p>

=SUMIF({range to match on}, matching criteria, {range to sum})<\/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":103954,"type":"question","name":"Formula to count multiple, same values in a cell","excerpt":"Hello, I am stumped trying to write a working formula to count multiple, same values in one cell. I used this formula but it is not returning the number I am looking for: =COUNTIF([DoorKing Summary]@row, CONTAINS(\"Yes\", @cell)) I also tried this formula without luck: =COUNTM([DoorKing Summary]@row, \"Yes\") I would like the…","categoryID":322,"dateInserted":"2023-04-12T19:37:16+00:00","dateUpdated":"2023-04-12T20:04:46+00:00","dateLastComment":"2023-04-13T16:39:31+00:00","insertUserID":119439,"insertUser":{"userID":119439,"name":"Lisa Matthews","title":"","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":"2023-04-13T15:22:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":119439,"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-04-13T16:43:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":78,"score":null,"hot":3362737007,"url":"https:\/\/community.smartsheet.com\/discussion\/103954\/formula-to-count-multiple-same-values-in-a-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103954\/formula-to-count-multiple-same-values-in-a-cell","format":"Rich","lastPost":{"discussionID":103954,"commentID":371659,"name":"Re: Formula to count multiple, same values in a cell","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/371659#Comment_371659","dateInserted":"2023-04-13T16:39:31+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-04-13T16:43:29+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\/45F0VPJHHICS\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-04-13T15:22:02+00:00","dateAnswered":"2023-04-13T11:42:58+00:00","acceptedAnswers":[{"commentID":371587,"body":"

In cases like this, we have to count how many characters are in the full string then subtract from that the number of characters left when we remove all instances of the word we are looking for. We then divide that number by the number of characters in the desired word (in this case 3).<\/p>

<\/p>

=(LEN([DoorKing Summary]@row) - LEN(SUBSTITUTE([DoorKing Summary]@row, \"Yes\", \"//www.santa-greenland.com/community/discussion/\"))) \/ 3<\/p>

<\/p>

Using the example of the second cell, you have 15 total characters. Subtract 12 from that (since we are removing one \"Yes\"), and we get 3. 3 divided by 3 equals 1.<\/p>

=(15 - 12) \/ 3<\/p>

<\/p>

The first cell has 33 characters. 24 Characters remain after removing all \"Yes\" instances giving us 9. 9 divided by 3 = 3.<\/p>

=(33 - 24) \/ 3<\/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":103933,"type":"question","name":"IF Function to multiply 2 numbers if the value of a column is greater than 1.99","excerpt":"Hi So I have a current set up in smartsheet, i have the sheet to figure out total time between 2 times. Now I need to do that TOTAL TIME multiplied by No of days BUT Only when the \"No of Days\" is 2 or greater. Can anybody help with this please?","categoryID":322,"dateInserted":"2023-04-12T15:52:45+00:00","dateUpdated":null,"dateLastComment":"2023-04-13T10:44:42+00:00","insertUserID":143411,"insertUser":{"userID":143411,"name":"Dan_H","url":"https:\/\/community.smartsheet.com\/profile\/Dan_H","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/I2Y9GXV4GL2X\/nB5V72AI7T35E.jpg","dateLastActive":"2023-04-13T15:31:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":143411,"lastUser":{"userID":143411,"name":"Dan_H","url":"https:\/\/community.smartsheet.com\/profile\/Dan_H","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/I2Y9GXV4GL2X\/nB5V72AI7T35E.jpg","dateLastActive":"2023-04-13T15:31:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3362698647,"url":"https:\/\/community.smartsheet.com\/discussion\/103933\/if-function-to-multiply-2-numbers-if-the-value-of-a-column-is-greater-than-1-99","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103933\/if-function-to-multiply-2-numbers-if-the-value-of-a-column-is-greater-than-1-99","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":103933,"commentID":371581,"name":"Re: IF Function to multiply 2 numbers if the value of a column is greater than 1.99","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/371581#Comment_371581","dateInserted":"2023-04-13T10:44:42+00:00","insertUserID":143411,"insertUser":{"userID":143411,"name":"Dan_H","url":"https:\/\/community.smartsheet.com\/profile\/Dan_H","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/I2Y9GXV4GL2X\/nB5V72AI7T35E.jpg","dateLastActive":"2023-04-13T15:31: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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-04-13T11:54:22+00:00","dateAnswered":"2023-04-12T16:40:55+00:00","acceptedAnswers":[{"commentID":371444,"body":"

Hello @Dan_H<\/a> <\/p>

Have you tried =IF([No of Days]@row >= 2, [Total Time]@row * [No of Days]@row, \"Whatever you want here\")?<\/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"}]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">