公式

= COUNTIFS(Rating:Rating, \"High-3\",…","categoryID":322,"dateInserted":"2022-06-17T06:31:19+00:00","dateUpdated":"2022-06-17T09:16:58+00:00","dateLastComment":"2022-06-17T12:55:39+00:00","insertUserID":145296,"insertUser":{"userID":145296,"name":"Ann11","url":"https:\/\/community.smartsheet.com\/profile\/Ann11","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-17T06:31:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"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":"2022-06-17T12:58:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":11,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/92315\/if-column-does-not-contain-string-return-n-a","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92315\/if-column-does-not-contain-string-return-n-a","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/7F6095QH40S5\/screen-shot-2022-06-17-at-3-58-24-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"Screen Shot 2022-06-17 at 3.58.24 pm.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-17T12:55:39+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}]},{"discussionID":92311,"type":"question","name":"IFERROR Not working for NETWORKDAY","excerpt":"Here is the formula I am trying to use, ideally the cell would just be blank if there was an error. I've tried rearranging in almost everyway I can think but I still keep getting #UNPARSEABLE. =IFERROR(NETWORKDAY([Estimate Status Date]@row,[Proposal Sent]@row)\"\") Thanks in advance!","categoryID":322,"dateInserted":"2022-06-17T03:25:40+00:00","dateUpdated":"2022-06-17T09:17:12+00:00","dateLastComment":"2022-06-17T12:48:03+00:00","insertUserID":149150,"insertUser":{"userID":149150,"name":"Nlondon","url":"https:\/\/community.smartsheet.com\/profile\/Nlondon","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-17T12:29:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"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":"2022-06-17T12:58:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":14,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/92311\/iferror-not-working-for-networkday","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92311\/iferror-not-working-for-networkday","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-17T12:48:03+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":339,"urlcode":"error","name":"Error"}],"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}]},{"discussionID":92253,"type":"question","name":"How to sum all the numbers where there is a letter together with the numbers in the cell?","excerpt":"Hello, I need some help adding all the hours in the range, but in each cell there will be a letter: I need to get '20' without any letters. Is it possible to do? Thank you in advance!","categoryID":322,"dateInserted":"2022-06-16T14:15:26+00:00","dateUpdated":"2022-06-16T14:15:57+00:00","dateLastComment":"2022-06-17T12:44:48+00:00","insertUserID":142980,"insertUser":{"userID":142980,"name":"Patrikas","url":"https:\/\/community.smartsheet.com\/profile\/Patrikas","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5RDquVoib0s!w58rN_42Aus!u6E4SFJ1YjH","dateLastActive":"2022-06-17T12:43:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":142980,"lastUser":{"userID":142980,"name":"Patrikas","url":"https:\/\/community.smartsheet.com\/profile\/Patrikas","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5RDquVoib0s!w58rN_42Aus!u6E4SFJ1YjH","dateLastActive":"2022-06-17T12:43:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":8,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/92253\/how-to-sum-all-the-numbers-where-there-is-a-letter-together-with-the-numbers-in-the-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92253\/how-to-sum-all-the-numbers-where-there-is-a-letter-together-with-the-numbers-in-the-cell","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/518E38AXGZKH\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-16T14:26:32+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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}]},{"discussionID":92294,"type":"question","name":"Unique filter","excerpt":"Can someone help me with the below formula? I am trying to count unique values within a column that also have a specific condition. =COUNTIFS, DISTINCT({CBA - Master Range 4}, {CBA - Master Range 2}, \"Accepted\", {CBA - Master Range 1}, =Title@row)","categoryID":322,"dateInserted":"2022-06-16T19:59:20+00:00","dateUpdated":"2022-06-17T09:18:20+00:00","dateLastComment":"2022-06-17T12:39:19+00:00","insertUserID":148479,"insertUser":{"userID":148479,"name":"AGM","url":"https:\/\/community.smartsheet.com\/profile\/AGM","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!najfn06BlBY!msFcX_bF1Po!ASvZ1eRV5Ye","dateLastActive":"2022-06-17T16:37:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"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":"2022-06-17T12:58:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":11,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/92294\/unique-filter","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92294\/unique-filter","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-17T12:39:19+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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}]},{"discussionID":92242,"type":"question","name":"Index Match inbounce limitation?","excerpt":"Hi, As I known that Vlookup has a limitation that cannot reference more than 100,000 cells and cannot have more than 100 unique cross sheet references in one sheet.(https:\/\/community.smartsheet.com\/discussion\/68137\/vlookups-in-smartsheet-are-there-limitations) Question : I have a table with 7 columns(1 for identifier\/6 for…","categoryID":322,"dateInserted":"2022-06-16T06:58:57+00:00","dateUpdated":"2022-06-16T11:03:38+00:00","dateLastComment":"2022-06-17T12:28:48+00:00","insertUserID":147314,"insertUser":{"userID":147314,"name":"VincentW","url":"https:\/\/community.smartsheet.com\/profile\/VincentW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-17T01:39:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"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":"2022-06-17T12:58:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":9,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/92242\/index-match-inbounce-limitation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92242\/index-match-inbounce-limitation","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-06-17T01:41:10+00:00","dateAnswered":"2022-06-16T16:21:29+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">