在Large函数中使用Collect函数

Allison_S
Allison_S ✭
编辑12/09/19 在内容基本知识

你好所有的,

我试图在LARGE函数内嵌套一个标准。我在我的工作表中有2个级别的孩子，我已经放置了一个层次结构列，这样我就可以选择具有“2”的层次结构等级的孩子为LARGE函数。我的公式下面，但它抛出错误。任何帮助将不胜感激!

=大(收集((层次)@row， =2)，[总销售金额]:[总销售金额])，((电子邮件保护)））

· 在Facebook上分享 在Twitter上分享

评论

  • Brian W
    Brian W ✭✭

    试试这样做:

    =LARGE(COLLECT([Total Sales Dollars]:[Total Sales Dollars]， Hierarchy:Hierarchy, 2)，(电子邮件保护)）

    · 在Facebook上分享 在Twitter上分享
  • Allison_S
    Allison_S ✭
    编辑05/14/19

    布莱恩，这真是太棒了!谢谢你！我现在正试图返回与前10美元金额相对应的信息，但它偶尔工作(见附件图片)。它返回一些值，而其他值则留空。这是我的配方，有什么建议吗?

    =INDEX(CHILDREN(ASIN:ASIN)， MATCH([Top 10 $])@row，[总销售金额]:[总销售金额]，0))

    截屏时间:2019-05-14上午8.19.57

    · 在Facebook上分享 在Twitter上分享
  • Brian W
    Brian W ✭✭

    所以，儿童在公式中是这样运作的:

    MATCH返回行号(N)， INDEX返回ASIN列中的第N个子行

    我确定这不会返回你期望的结果。

    在没有看到整个表格的情况下，很难想出解决方案。你能分享更多关于你希望CHILDREN如何在配方中发挥作用的信息吗?

    · 在Facebook上分享 在Twitter上分享

类别

@Frank B.<\/a> If the folders are in the same Workspace that the sheets currently reside, there will for sure be no impact.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":371,"urlcode":"WorkApps","name":"WorkApps"},{"tagID":443,"urlcode":"dynamic-view","name":"Dynamic View"}]},{"discussionID":106272,"type":"question","name":"Automation to send past due notifications to members","excerpt":"Hi All! I hope someone can help me create a (functioning!) automation. I need Smarsheets to send a daily notification to task owners, if the task is marked past due. Currently, I have been able to create an automation that will alert owners when a task becomes past due; however, this is a one-time notification. I've…","categoryID":321,"dateInserted":"2023-06-09T14:40:21+00:00","dateUpdated":"2023-06-09T14:48:10+00:00","dateLastComment":"2023-06-09T15:01:14+00:00","insertUserID":162249,"insertUser":{"userID":162249,"name":"blake_smith_b","title":"Accountant - Financial Reporting","url":"https:\/\/community.smartsheet.com\/profile\/blake_smith_b","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T15:10:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":142964,"lastUser":{"userID":142964,"name":"Ray Lindstrom","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Lindstrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5Y0KP6UKIBTU\/nY3615V0DPRZV.jpg","dateLastActive":"2023-06-09T16:08:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":3372645095,"url":"https:\/\/community.smartsheet.com\/discussion\/106272\/automation-to-send-past-due-notifications-to-members","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106272\/automation-to-send-past-due-notifications-to-members","format":"Rich","tagIDs":[334,510],"lastPost":{"discussionID":106272,"commentID":379850,"name":"Re: Automation to send past due notifications to members","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379850#Comment_379850","dateInserted":"2023-06-09T15:01:14+00:00","insertUserID":142964,"insertUser":{"userID":142964,"name":"Ray Lindstrom","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Lindstrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5Y0KP6UKIBTU\/nY3615V0DPRZV.jpg","dateLastActive":"2023-06-09T16:08:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/XJX8FMEG7M9C\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T15:12:48+00:00","dateAnswered":"2023-06-09T15:01:14+00:00","acceptedAnswers":[{"commentID":379850,"body":"

In the Trigger section, select \"When a date is reached\",<\/p>

Then select \"Custom\" for when to run the automation, and select \"Repeat Every\" and choose 1 Day.<\/p>

Then select your Conditions. For yours, you can say \"Where Past Due?\", and select \"is one of\", then choose \"Past Due\"<\/p>

Example below.<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":334,"urlcode":"automations","name":"Automations"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}]},{"discussionID":106257,"type":"question","name":"Bulk download of all the PDF attachments in a worksheet","excerpt":"Hello Community, I am quite new to the Smartsheet and came here to get some advice from you all, i would like to know if there is a way to download all the PDFs attached in different rows of worksheet at one go if the attachments are more than 1000, it would be very helpful if you can guide me through the process, i am a…","categoryID":321,"dateInserted":"2023-06-09T11:58:50+00:00","dateUpdated":"2023-06-09T11:59:59+00:00","dateLastComment":"2023-06-09T16:29:33+00:00","insertUserID":162243,"insertUser":{"userID":162243,"name":"Pragati Trivedi","url":"https:\/\/community.smartsheet.com\/profile\/Pragati%20Trivedi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T16:27:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":162243,"lastUser":{"userID":162243,"name":"Pragati Trivedi","url":"https:\/\/community.smartsheet.com\/profile\/Pragati%20Trivedi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T16:27:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3372641303,"url":"https:\/\/community.smartsheet.com\/discussion\/106257\/bulk-download-of-all-the-pdf-attachments-in-a-worksheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106257\/bulk-download-of-all-the-pdf-attachments-in-a-worksheet","format":"Rich","tagIDs":[268],"lastPost":{"discussionID":106257,"commentID":379882,"name":"Re: Bulk download of all the PDF attachments in a worksheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379882#Comment_379882","dateInserted":"2023-06-09T16:29:33+00:00","insertUserID":162243,"insertUser":{"userID":162243,"name":"Pragati Trivedi","url":"https:\/\/community.smartsheet.com\/profile\/Pragati%20Trivedi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T16:27:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T16:27:29+00:00","dateAnswered":"2023-06-09T16:01:48+00:00","acceptedAnswers":[{"commentID":379871,"body":"

@Pragati Trivedi<\/a> <\/p>

If you open the attachments using the icon on the right and you have appropriate level of rights to do this, you can download all. I don't know if there is a size or quantity limit.<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

Another option is to select multiple files and download groups of files.<\/p>

Hope this helps!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":268,"urlcode":"Attachments","name":"Attachments"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势

  • 将智能表组织到文件夹中-对DVs和WorkApps的影响

    你好，我正试图在Smartsheet中组织工作空间列表。如果我创建文件夹并将工作表移动到不同的文件夹中，这会使动态视图和工作应用程序混乱吗?谢谢你,弗兰克

  • 自动向成员发送过期通知

    嗨!我希望有人能帮助我创建一个(功能!)自动化。我需要智能表发送每日通知的任务所有者，如果任务被标记过去到期。目前，我已经能够创建一个自动化，将提醒业主当一个任务变得过期;然而，这是一个一次性通知。我已经……

  • 批量下载工作表中的所有PDF附件

    你好，社区，我对智能表很陌生，来到这里是为了得到你们所有人的一些建议，我想知道如果附件超过1000个，是否有一种方法可以一次性下载不同行工作表中附加的所有pdf，如果你能指导我完成这个过程，那将非常有帮助，我是一个…