整体平均竞争率

0, [% Complete]@row < 1), \"In Progress\", IF([% Complete]@row = 0, \"Not Started\"))) I want to add in…","categoryID":322,"dateInserted":"2023-06-07T14:52:30+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T15:16:49+00:00","insertUserID":157541,"insertUser":{"userID":157541,"name":"ro.fei","title":"","url":"https:\/\/community.smartsheet.com\/profile\/ro.fei","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4OWA5DDSR8JB\/n2H4UP1N6TZA6.jpg","dateLastActive":"2023-06-07T15:16:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":157541,"lastUser":{"userID":157541,"name":"ro.fei","title":"","url":"https:\/\/community.smartsheet.com\/profile\/ro.fei","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4OWA5DDSR8JB\/n2H4UP1N6TZA6.jpg","dateLastActive":"2023-06-07T15:16:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":13,"score":null,"hot":3372301159,"url":"https:\/\/community.smartsheet.com\/discussion\/106137\/trying-to-determine-if-all-children-have-n-a-status","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106137\/trying-to-determine-if-all-children-have-n-a-status","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106137,"commentID":379294,"name":"Re: Trying to determine if all children have N\/A Status","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379294#Comment_379294","dateInserted":"2023-06-07T15:16:49+00:00","insertUserID":157541,"insertUser":{"userID":157541,"name":"ro.fei","title":"","url":"https:\/\/community.smartsheet.com\/profile\/ro.fei","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4OWA5DDSR8JB\/n2H4UP1N6TZA6.jpg","dateLastActive":"2023-06-07T15:16:57+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-06-07T15:16:56+00:00","dateAnswered":"2023-06-07T15:16:49+00:00","acceptedAnswers":[{"commentID":379294,"body":"

I got it! It's long but it works:<\/p>

<\/p>

=IF(AND(CONTAINS(\"N\/A\", CHILDREN(STATUS@row)), CONTAINS(\"Not Started\", CHILDREN(STATUS@row)) = false, CONTAINS(\"In Progress\", CHILDREN(STATUS@row)) = false, CONTAINS(\"Complete\", CHILDREN(STATUS@row)) = false), \"N\/A\", IF([% Complete]@row = 1, \"Complete\", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), \"In Progress\", IF([% Complete]@row = 0, \"Not Started\"))))<\/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":106136,"type":"question","name":"I am trying to manipulate my SUMIFs Formula","excerpt":"When Using SUMIFS(Range, Criterion Range 1,Criterion...) I have multiple columns for example Estimate Spend, 25% spend, 50% spend, Rather than having multiple %'s of spend I just want to be able to use 1 reference and multiply it by 0.25 or 0.5 in the first \"Range\" category so =SUMIFS({Spend} * 0.25, {Phase}, \"phase 1\",…","categoryID":322,"dateInserted":"2023-06-07T14:39:19+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T14:56:44+00:00","insertUserID":155241,"insertUser":{"userID":155241,"name":"Mathew Palter","url":"https:\/\/community.smartsheet.com\/profile\/Mathew%20Palter","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxYml_p2w4ZGEQsYcizl1E0LV2zWrFZLuG5E2D3h=s96-c","dateLastActive":"2023-06-07T16:05:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":155241,"lastUser":{"userID":155241,"name":"Mathew Palter","url":"https:\/\/community.smartsheet.com\/profile\/Mathew%20Palter","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxYml_p2w4ZGEQsYcizl1E0LV2zWrFZLuG5E2D3h=s96-c","dateLastActive":"2023-06-07T16:05:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":null,"hot":3372299763,"url":"https:\/\/community.smartsheet.com\/discussion\/106136\/i-am-trying-to-manipulate-my-sumifs-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106136\/i-am-trying-to-manipulate-my-sumifs-formula","format":"Rich","tagIDs":[219,254,319,334,445],"lastPost":{"discussionID":106136,"commentID":379290,"name":"Re: I am trying to manipulate my SUMIFs Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379290#Comment_379290","dateInserted":"2023-06-07T14:56:44+00:00","insertUserID":155241,"insertUser":{"userID":155241,"name":"Mathew Palter","url":"https:\/\/community.smartsheet.com\/profile\/Mathew%20Palter","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxYml_p2w4ZGEQsYcizl1E0LV2zWrFZLuG5E2D3h=s96-c","dateLastActive":"2023-06-07T16:05: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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-07T14:56:07+00:00","dateAnswered":"2023-06-07T14:43:39+00:00","acceptedAnswers":[{"commentID":379282,"body":"

@Mathew Palter<\/a> <\/p>

Would =SUMIFS({Spend}, {Phase}, \"phase 1\", {Status}, \"IN PROGRESS\")*0.25 not work? It just takes the sum then multiply it by 25%. You can do the same for 50%<\/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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}]},{"discussionID":106129,"type":"question","name":"Quiz scoring","excerpt":"Need a proper formula to count each correct answer on a row. with inspections it is safe or at risk which is easy to count, but i can figure out how to count each column with different answer. I came up with this =COUNTIFS([Reason forklift safety is important]@row, \"D. All of the above\", [Primary sources of fuel]@row, \"D.…","categoryID":322,"dateInserted":"2023-06-07T13:54:27+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T15:00:24+00:00","insertUserID":132359,"insertUser":{"userID":132359,"name":"Kyle Black","url":"https:\/\/community.smartsheet.com\/profile\/Kyle%20Black","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3Zddf9L-k7w!8sDQ90it9NQ!7sc5AJ6VerR","dateLastActive":"2023-06-07T14:58:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":132359,"lastUser":{"userID":132359,"name":"Kyle Black","url":"https:\/\/community.smartsheet.com\/profile\/Kyle%20Black","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3Zddf9L-k7w!8sDQ90it9NQ!7sc5AJ6VerR","dateLastActive":"2023-06-07T14:58:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":null,"hot":3372297291,"url":"https:\/\/community.smartsheet.com\/discussion\/106129\/quiz-scoring","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106129\/quiz-scoring","format":"Rich","lastPost":{"discussionID":106129,"commentID":379293,"name":"Re: Quiz scoring","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379293#Comment_379293","dateInserted":"2023-06-07T15:00:24+00:00","insertUserID":132359,"insertUser":{"userID":132359,"name":"Kyle Black","url":"https:\/\/community.smartsheet.com\/profile\/Kyle%20Black","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3Zddf9L-k7w!8sDQ90it9NQ!7sc5AJ6VerR","dateLastActive":"2023-06-07T14:58:38+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\/KARXKDBS5IKA\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-07T14:59:49+00:00","dateAnswered":"2023-06-07T14:11:48+00:00","acceptedAnswers":[{"commentID":379271,"body":"

=COUNTIF([Primary sources of fuel]@row, \"D. All of the above\") + COUNTIF([Operator is not required to wear seat belt]@row, \"E. The operator is alwa...) + COUNTIF([major difference between car and forklift]@row, \"D. All of the above\") + ...<\/p>

You should be able to finish the formula based on this. This will work, but this will be a very long formula. Maybe someone can suggest a more concise approach.<\/p>

<\/p>

COUNTIFS is not meant to count multiple things. Its purpose is to verify that something meets multiple criteria before being counted.<\/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":[]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">