支持

= 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-29T00:17:15+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-07-06T07:34:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":145296,"lastUser":{"userID":145296,"name":"Ann11","url":"https:\/\/community.smartsheet.com\/profile\/Ann11","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-07-06T07:34:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":47,"score":null,"hot":3311914114,"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":"","1600":""},"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":92550,"type":"question","name":"Correcting WeekOf and Avg Formulas","excerpt":"Hi all! I am trying to do 2 operations on some columns I have in a sheet. I have written (with your help ofc!) 2 formulas to fit my needs, these are a week of, and a avg formula. To be more specific, I have a sheet that has tasks on it. Assigned to these tasks are days it took to complete them, as well as the day of…","categoryID":322,"dateInserted":"2022-06-23T13:00:56+00:00","dateUpdated":"2022-06-23T13:03:51+00:00","dateLastComment":"2022-06-27T11:56:22+00:00","insertUserID":148853,"insertUser":{"userID":148853,"name":"Muhammad","url":"https:\/\/community.smartsheet.com\/profile\/Muhammad","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-07-04T12:53:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":148853,"lastUser":{"userID":148853,"name":"Muhammad","url":"https:\/\/community.smartsheet.com\/profile\/Muhammad","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-07-04T12:53:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":39,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/92550\/correcting-weekof-and-avg-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92550\/correcting-weekof-and-avg-formulas","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/J7P70KIWB005\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-07-04T12:54:49+00:00","dateAnswered":"2022-06-24T22:46:55+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":265,"urlcode":"Reports","name":"Reports"},{"tagID":281,"urlcode":"Support","name":"Support"}],"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}">