整体平均竞争率
你好,
我已经环顾四周的多种形式，并没有能够找到一个解决方案，为什么我的公式不工作。我试图确定的公式为总项目%完成的孩子行。
对于Project Initiation行，我有公式=ROUND(IF(COUNTIF(CHILDREN()， 1) / COUNT(CHILDREN()) > 0, COUNTIF(CHILDREN()， 1) / COUNT(CHILDREN())， 0) * 100,0) + "%"
为完成?11cell I tried to use the formula =AVG(CHILDREN()) and I get a #DIVIDE BY ZERO error.
我如何得到完成?11cell to show me the total percentage for the entire project? Please note this sheet is for project templates.
评论
-
TKeller ✭✭✭你好,玛西娅,
您是否尝试过使用%完成系统列?只要你的项目标题是最上面的父项，其他的都是下面的子项，它就会自动计算总体完成百分比。(您确实需要启用持续时间和前任，但这有助于管理整个项目)。
希望这对你有所帮助
-
保罗新来的 ✭✭✭✭✭✭我建议创建一个隐藏的helper列(在本例中我们称之为“helper”)。
在helper列的每个父行中使用
=圆(如果条件统计(孩子([完成吗?］@row)， 1) / COUNT(CHILDREN([Complete?]］@row))> 0, COUNTIF(CHILDREN([Complete?]］@row)， 1) / COUNT(CHILDREN([Complete?]］@row))， 0) * 100, 0)
这将给你号码。在[Complete?]］column, you can enter
(电子邮件保护)+“%”
这将把你的数字和百分号结合起来。
对于整个行，您将在Helper列中输入
=圆(AVG(儿童()),0)
thinkspi.com
-
上面说你让我输入的第一个公式是#不可解析。我想知道平均公式不起作用的原因是因为儿童行中有一个公式。
-
嗨TKeller,
我不熟悉%完成系统列。最父行为任务名称第11行。
-
她名叫Stara ✭✭✭✭✭✭你好,玛西娅,
%完成和其他项目表列是伟大的。
更多信息请见附件链接/截图。
我希望这对你有帮助!
祝你周末愉快!
最好的
她名叫Stara
工作流程顾问@完成咨询
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
如果我给你这个项目的链接也许会有帮助
https://app.smartsheet.com/b/publish?EQBCT=3fb3cc4472c441378a412fc0d57ff82e
-
她名叫Stara ✭✭✭✭✭✭
看看这里的项目表，以及如何使用Smartsheet中的自动功能的完成百分比。
https://app.smartsheet.com/b/publish?EQBCT=63979e622cc14da2a4b938194d31..。
这样行吗?
最好的
她名叫
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
这似乎对我的项目不起作用，我想因为我想求平均值的列是一个复选框列。
-
太有帮助了，谢谢你!
-
她名叫Stara ✭✭✭✭✭✭
是的，这将不起作用，因为它必须是一个数字/文本列。如果一定要有复选框，就必须按照Paul建议的方式来做。
最好的
她名叫
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
DMark ✭
保罗，我知道这是一个旧的帖子，但它非常有帮助。通过剖析它，并将我所学到的应用到公式中，我能够解决很多其他问题。谢谢你！
帮助文章参考资料欧宝体育app官方888
类别
=INDEX([1st Date Column]@row:[Last Date Column]@row, 1, Index@row)<\/p>
<\/p>
You are going to need to update the column names in the formula to match what you are using in your sheet.<\/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":106087,"type":"question","name":"Conditional Formatting Based on 2 Date Columns, with or without Helper Column","excerpt":"Hi! I've scoured the Community posts, and can't find exactly what I need. I am managing a membership list and need to flag when memberships expire before or on a specific date (06\/29\/2023) so I can contact those members. I have one column with their membership expiration dates, a second column with the 06\/29\/2023 deadline,…","categoryID":322,"dateInserted":"2023-06-06T18:29:42+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T19:02:02+00:00","insertUserID":162111,"insertUser":{"userID":162111,"name":"Mlichtenstein","title":"Director","url":"https:\/\/community.smartsheet.com\/profile\/Mlichtenstein","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BtDbwegK_WQ!wlnbvxwzuT4!fyPHolHHR0X","dateLastActive":"2023-06-06T18:55:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162111,"lastUser":{"userID":162111,"name":"Mlichtenstein","title":"Director","url":"https:\/\/community.smartsheet.com\/profile\/Mlichtenstein","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BtDbwegK_WQ!wlnbvxwzuT4!fyPHolHHR0X","dateLastActive":"2023-06-06T18:55:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":46,"score":null,"hot":3372157304,"url":"https:\/\/community.smartsheet.com\/discussion\/106087\/conditional-formatting-based-on-2-date-columns-with-or-without-helper-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106087\/conditional-formatting-based-on-2-date-columns-with-or-without-helper-column","format":"Rich","tagIDs":[437],"lastPost":{"discussionID":106087,"commentID":379120,"name":"Re: Conditional Formatting Based on 2 Date Columns, with or without Helper Column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379120#Comment_379120","dateInserted":"2023-06-06T19:02:02+00:00","insertUserID":162111,"insertUser":{"userID":162111,"name":"Mlichtenstein","title":"Director","url":"https:\/\/community.smartsheet.com\/profile\/Mlichtenstein","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BtDbwegK_WQ!wlnbvxwzuT4!fyPHolHHR0X","dateLastActive":"2023-06-06T18:55:36+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\/JWT4M72YQK8N\/screenshot-2023-06-06-142808.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-06-06 142808.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-06T19:00:34+00:00","dateAnswered":"2023-06-06T18:52:14+00:00","acceptedAnswers":[{"commentID":379113,"body":"
@Mlichtenstein<\/a> <\/p> @Eric Law<\/a> - you are speedy 😊<\/span><\/p> Another option would be to us a Sheet Summary field for the Expiration Helper Column - Mtg Date instead of a column in the sheet.<\/p> Flag column formula: =IFERROR(IF([Membership Expiration]@row <= [Expiration Helper Column - Mtg Date]#, 1, 0), \"No Date\")<\/p> Sheet Summary field (Expiration Helper Column - Mtg Date would equal 6\/29\/23<\/p> Hope this helps. <\/p> Thanks -Peggy<\/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":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}]},{"discussionID":106073,"type":"question","name":"CRM Templates and Formula for tracking company change","excerpt":"Hello all, Two part question: What success have you had using the Smartsheet CRM templates? We have decent adoption with Smartsheet, and no adoption with salesforce, so are looking to do our CRM in Smartsheet and leverage the data we already have (client info, contracts, etc) Second, I am looking for a way (formula,…","categoryID":322,"dateInserted":"2023-06-06T15:59:35+00:00","dateUpdated":"2023-06-06T16:06:41+00:00","dateLastComment":"2023-06-06T20:09:40+00:00","insertUserID":137695,"insertUser":{"userID":137695,"name":"Tim Starkey","url":"https:\/\/community.smartsheet.com\/profile\/Tim%20Starkey","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uolS96T7mzo!84NRtwSFw3o!n5WODiM4TKP","dateLastActive":"2023-06-06T20:09:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":91566,"lastUserID":137695,"lastUser":{"userID":137695,"name":"Tim Starkey","url":"https:\/\/community.smartsheet.com\/profile\/Tim%20Starkey","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uolS96T7mzo!84NRtwSFw3o!n5WODiM4TKP","dateLastActive":"2023-06-06T20:09:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":28,"score":null,"hot":3372151155,"url":"https:\/\/community.smartsheet.com\/discussion\/106073\/crm-templates-and-formula-for-tracking-company-change","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106073\/crm-templates-and-formula-for-tracking-company-change","format":"Rich","lastPost":{"discussionID":106073,"commentID":379148,"name":"Re: CRM Templates and Formula for tracking company change","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379148#Comment_379148","dateInserted":"2023-06-06T20:09:40+00:00","insertUserID":137695,"insertUser":{"userID":137695,"name":"Tim Starkey","url":"https:\/\/community.smartsheet.com\/profile\/Tim%20Starkey","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uolS96T7mzo!84NRtwSFw3o!n5WODiM4TKP","dateLastActive":"2023-06-06T20:09:55+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-06T20:09:52+00:00","dateAnswered":"2023-06-06T17:41:26+00:00","acceptedAnswers":[{"commentID":379092,"body":" Hi @Tim Starkey<\/a> <\/p> I hope you're well and safe!<\/p> I've developed a couple of CRM solutions for clients. The latest one was the most advanced; in short, we have a Company sheet, Contacts sheet, Opportunities sheet, and more. Combined with forms, Data Shuttle and DataMesh.<\/p> So, yes, it's possible to do what you need, but yours may not need to be as advanced.<\/p> You could store the history in a so-called log sheet.<\/p> Make sense?<\/p> I hope that helps!<\/p> Be safe, and have a fantastic week!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":[]}">
![\"Conditional](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/DD8Q3FFV2RUK\/conditional-formating.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
