复杂索引/匹配参数问题:项目更新任务列表
我的经理要求我从一个行层次结构中引用多列的数据，但希望从CHILDREN行中的数据输入更新Parent Row，然后他要求所选客户的最新更新。我需要PARENT行自动更新，每当一个CHILD行已更新或添加。我的想法是使用INDEX/MATCH函数拉出我需要的特定返回单元格，但我无法思考的问题是如何为修改的列拉出最新更新的MATCH，并为最近更新的CHILD行索引项目评级状态。
我有一个世界的麻烦，试图找到使用这些嵌套函数的最佳方法来自动化我的父行。
如果有人能给我指引正确的方向?
我有这个未完成的函数的许多变体拉特定的输入，但我的数据总是读为#UNPARSEABLE。
下面是过于复杂的函数:
INDEX(CHILDREN([项目评级状态]1):CHILDREN([修改]1)，MATCH(MAX(COLLECT(CHILDREN([修改]1)，CHILDREN([项目评级状态]1)，@cell <>""))， CHILDREN([项目评级状态]):CHILDREN([修改]1)，0)，CHILDREN([项目评级状态]1)
最佳答案
-
她名叫Stara ✭✭✭✭✭✭我希望你一切安好!
试试这样的方法。
=指数(儿童(),匹配(MAX(儿童((电子邮件保护))),儿童((电子邮件保护)）））
那有用吗?
我希望这能有所帮助!
注意安全，祝你周末愉快!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请通过以下方式支持社区将其标记为有见地/投票赞成或/和作为可接受的答案．这将使别人更容易找到解决方案或帮助回答!
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时联系我有关Smartsheet的帮助，集成，一般的工作流程建议，或其他完全的东西。
1
答案
-
她名叫Stara ✭✭✭✭✭✭
我希望你一切安好!
试试这样的方法。
=指数(儿童(),匹配(MAX(儿童((电子邮件保护))),儿童((电子邮件保护)）））
那有用吗?
我希望这能有所帮助!
注意安全，祝你周末愉快!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请通过以下方式支持社区将其标记为有见地/投票赞成或/和作为可接受的答案．这将使别人更容易找到解决方案或帮助回答!
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时联系我有关Smartsheet的帮助，集成，一般的工作流程建议，或其他完全的东西。
1
帮助文章资源欧宝体育app官方888
类别
- Create a date column to track when the task is completed<\/li>
- Create a workflow automation to record a date in that column when the status changes to \"Complete\"<\/li><\/ol>
<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-23 01:13:21","updateUser":{"userID":150538,"name":"Preston P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Preston%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nWVKDFTEFOKBN.png","dateLastActive":"2022-09-23T01:19:53+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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":95791,"type":"question","name":"COUNTIF\/CONTAINS","excerpt":"Hello, I am attempting to count how many times a specific word appears in a text entry in a column. I normally achieve this by filtering by \"contains\" on the actual data sheet. My goal here is to automate this with a formula. Example: Count how many times the Resolution column contains \"duplicate\" I have tried the COUNTIF…","categoryID":322,"dateInserted":"2022-09-22T15:33:14+00:00","dateUpdated":null,"dateLastComment":"2022-09-22T17:12:39+00:00","insertUserID":152723,"insertUser":{"userID":152723,"name":"chelsi.johnson","url":"https:\/\/community.smartsheet.com\/profile\/chelsi.johnson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wx9nv0OzvvM!c5lk5xPUwzs!ncykvroFsEa","dateLastActive":"2022-09-22T19:03:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":152723,"lastUser":{"userID":152723,"name":"chelsi.johnson","url":"https:\/\/community.smartsheet.com\/profile\/chelsi.johnson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wx9nv0OzvvM!c5lk5xPUwzs!ncykvroFsEa","dateLastActive":"2022-09-22T19:03:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3327728753,"url":"https:\/\/community.smartsheet.com\/discussion\/95791\/countif-contains","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95791\/countif-contains","format":"Rich","lastPost":{"discussionID":95791,"commentID":344455,"name":"Re: COUNTIF\/CONTAINS","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344455#Comment_344455","dateInserted":"2022-09-22T17:12:39+00:00","insertUserID":152723,"insertUser":{"userID":152723,"name":"chelsi.johnson","url":"https:\/\/community.smartsheet.com\/profile\/chelsi.johnson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wx9nv0OzvvM!c5lk5xPUwzs!ncykvroFsEa","dateLastActive":"2022-09-22T19:03: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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/2Z271KRUD1QT\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-22T17:44:54+00:00","dateAnswered":"2022-09-22T15:45:40+00:00","acceptedAnswers":[{"commentID":344433,"body":"Hi @chelsi.johnson<\/a> <\/p>
I hope you're well and safe!<\/p>
Try something like this.<\/p>
=COUNTIFS(Resolution:Resolution, CONTAINS(\"Duplicate\", @cell))<\/p>
Did that work\/help? <\/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","log":{"dateUpdated":"2022-09-22 17:44:54","updateUser":{"userID":152723,"name":"chelsi.johnson","url":"https:\/\/community.smartsheet.com\/profile\/chelsi.johnson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wx9nv0OzvvM!c5lk5xPUwzs!ncykvroFsEa","dateLastActive":"2022-09-22T19:03:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":95792,"type":"question","name":"Two Dates, one independent and one dependent in one cell?","excerpt":"Does anyone know how or if I could create a dependent date based on an independent date in the same cell? I don't think this would work and may have to create a different column dependent on the independent date. The scenario is say meeting A is the independent date, Meeting B is a prep for Meeting A, which will take place…","categoryID":322,"dateInserted":"2022-09-22T15:33:54+00:00","dateUpdated":null,"dateLastComment":"2022-09-22T17:11:06+00:00","insertUserID":152722,"insertUser":{"userID":152722,"name":"kgibson","url":"https:\/\/community.smartsheet.com\/profile\/kgibson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-22T18:33:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":136737,"lastUser":{"userID":136737,"name":"Toufong Vang","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Toufong%20Vang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/n65S9PRP4PA0M.png","dateLastActive":"2022-09-22T19:20:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":27,"score":null,"hot":3327728100,"url":"https:\/\/community.smartsheet.com\/discussion\/95792\/two-dates-one-independent-and-one-dependent-in-one-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95792\/two-dates-one-independent-and-one-dependent-in-one-cell","format":"Rich","lastPost":{"discussionID":95792,"commentID":344454,"name":"Re: Two Dates, one independent and one dependent in one cell?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344454#Comment_344454","dateInserted":"2022-09-22T17:11:06+00:00","insertUserID":136737,"insertUser":{"userID":136737,"name":"Toufong Vang","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Toufong%20Vang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/n65S9PRP4PA0M.png","dateLastActive":"2022-09-22T19:20:48+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":"2022-09-22T18:33:28+00:00","dateAnswered":"2022-09-22T17:11:06+00:00","acceptedAnswers":[{"commentID":344454,"body":"
