多重标准相加
评论
-
尼克Burrus ✭✭✭✭✭✭
在sumif中,第一个引用需要是你试图“求和”的内容。
=SUMIFS([Sum],标准1,答案,标准2,答案)
Nick - Smartsheet产ob欧宝娱乐app手机下载品认证
St Nicholas Burrus博士DHA, PMP
我为美国政府、州政府和十多家美国财富100强企业制作智能表格。
-
Karrie戴维斯 优等生
谢谢你,尼克,
第一个参考是我要求和的。当前周的容量,但我想添加第二个条件,如果它是特定的工作类型,则求和。这就是我的问题所在。你能帮帮我吗?
谢谢你!
-
Karrie戴维斯 优等生
谢谢,我想明白了
-
她名叫Stara ✭✭✭✭✭✭
太好了!
很高兴你修好了!
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
帮助文章参考资料欧宝体育app官方888
类别
or this if you want to point to the name in the contact list without typing each:<\/p>
=COUNTIF({Product Backlog - Q360 Range 2}, FIND([Insert Contact Column Name]@row, @cell) >= 1)<\/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":106391,"type":"question","name":"Index formula versus If And","excerpt":"Hi, First time posting. I have several sheets I link together. Long story short is web applications pasted into one sheet populate into another for vetting for eligibility of employment. That sheet will then provide the data for my drop downs into the Active Sheet which will pull the corresponding rows of data based on the…","categoryID":322,"dateInserted":"2023-06-13T19:26:31+00:00","dateUpdated":"2023-06-14T09:06:24+00:00","dateLastComment":"2023-06-14T14:38:38+00:00","insertUserID":162337,"insertUser":{"userID":162337,"name":"maineL","title":"Admin. & Course Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/maineL","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!plNXqQdBs_o!2kvQ_7y42f4!PTHvB33mICN","dateLastActive":"2023-06-14T14:54:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":162337,"lastUser":{"userID":162337,"name":"maineL","title":"Admin. & Course Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/maineL","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!plNXqQdBs_o!2kvQ_7y42f4!PTHvB33mICN","dateLastActive":"2023-06-14T14:54:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":55,"score":null,"hot":3373441509,"url":"https:\/\/community.smartsheet.com\/discussion\/106391\/index-formula-versus-if-and","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106391\/index-formula-versus-if-and","format":"Rich","lastPost":{"discussionID":106391,"commentID":380504,"name":"Re: Index formula versus If And","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380504#Comment_380504","dateInserted":"2023-06-14T14:38:38+00:00","insertUserID":162337,"insertUser":{"userID":162337,"name":"maineL","title":"Admin. & Course Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/maineL","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!plNXqQdBs_o!2kvQ_7y42f4!PTHvB33mICN","dateLastActive":"2023-06-14T14:54:40+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\/K0XF0S5N57N6\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-14T14:55:00+00:00","dateAnswered":"2023-06-14T14:09:19+00:00","acceptedAnswers":[{"commentID":380493,"body":"
Right. You'll need to change the very first \"S\" to an \"F\" in the Fall column.<\/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":106366,"type":"question","name":"Array formulas for project completion in Smartsheet","excerpt":"Hello, I have a project plan in Smartsheet with 2 columns: % Complete Relative weight of completion This cells are used in parent rows (the phases of the project) and are used to indicate the completion of a phase but also the relative amount of effort that each phase has (as an average is not accurate enough) I would like…","categoryID":322,"dateInserted":"2023-06-13T12:58:24+00:00","dateUpdated":"2023-06-13T12:59:17+00:00","dateLastComment":"2023-06-13T17:47:52+00:00","insertUserID":162323,"insertUser":{"userID":162323,"name":"Ignacio de la Llave","url":"https:\/\/community.smartsheet.com\/profile\/Ignacio%20de%20la%20Llave","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtdcDDZaqcn-zSRDvB-hN8rvWiw8lpzQElqnGMtp=s96-c","dateLastActive":"2023-06-14T09:49:03+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":"2023-06-14T14:08:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":37,"score":null,"hot":3373341376,"url":"https:\/\/community.smartsheet.com\/discussion\/106366\/array-formulas-for-project-completion-in-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106366\/array-formulas-for-project-completion-in-smartsheet","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106366,"commentID":380352,"name":"Re: Array formulas for project completion in Smartsheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380352#Comment_380352","dateInserted":"2023-06-13T17:47:52+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-06-14T14:08: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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/ZMII8W5L8DT9\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-13T15:57:54+00:00","dateAnswered":"2023-06-13T15:47:01+00:00","acceptedAnswers":[{"commentID":380323,"body":"
I would suggest a helper column (can be hidden after setting up) that determines the weighted % on each parent row.<\/p>
=IF([Weight (% of Completion]@row <> \"\", [Weight (% of Completion]@row * [% Complete]@row)<\/p>
<\/p>
Then to add each piece together, you would use<\/p>
=SUM(CHILDREN([Helper Column]@row))<\/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"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":9983,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">