索引收集错误

霏欧纳莫里
霏欧纳莫里 ✭✭
在内容基本知识

你好!我试图使用INDEX COLLECT函数来获取数值。它使用以下内容:

  • 总数
  • 月度过滤器
  • 在两个表之间匹配名字

这是我正在使用的公式，它返回一个不正确的参数集错误。

=INDEX(COLLECT({OPK月报22-23未填写0-3}，{OPK月报22-23月}，"四月")，{OPK月报22-23受赠人名称}，((电子邮件保护)), 1)

任何帮助都非常感谢!

标签:
· 在Facebook上分享 在Twitter上分享

最佳答案

答案

类别

Hi @clawson<\/a> <\/p>

The Jira Connector would need to be purchased in addition to your Smartsheet plan. If your plan doesn't include this connector, you can contact the Sales team from this page. <\/a><\/p>

Here's more information: Smartsheet for Jira Connector: Overview<\/a><\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":106634,"type":"question","name":"Formula to set the Task Health.","excerpt":"Hi Good Morning, I have a question on this formula. Can you tell me what I did wrong please? Thanks for your great help.","categoryID":321,"dateInserted":"2023-06-20T14:28:24+00:00","dateUpdated":null,"dateLastComment":"2023-06-21T14:04:40+00:00","insertUserID":162441,"insertUser":{"userID":162441,"name":"AAL","title":"Automation - Record a Date","url":"https:\/\/community.smartsheet.com\/profile\/AAL","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-21T15:13:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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-21T15:10:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":12,"countViews":71,"score":null,"hot":3374634784,"url":"https:\/\/community.smartsheet.com\/discussion\/106634\/formula-to-set-the-task-health","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106634\/formula-to-set-the-task-health","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106634,"commentID":381484,"name":"Re: Formula to set the Task Health.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381484#Comment_381484","dateInserted":"2023-06-21T14:04:40+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-21T15:10:43+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\/Y9UHM44PUCBT\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-20T18:05:21+00:00","dateAnswered":"2023-06-20T17:22:23+00:00","acceptedAnswers":[{"commentID":381355,"body":"

Happy to help. 👍️<\/span><\/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":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106616,"type":"question","name":"Groups - how many users in a group?","excerpt":"The help files indicates you can bulk upload 1,000 emails to a group. Is that the maximum number of users that can be in a group? I could not find documentation indicating how many users could be in a group. TIA","categoryID":321,"dateInserted":"2023-06-19T21:51:09+00:00","dateUpdated":"2023-06-20T08:19:00+00:00","dateLastComment":"2023-06-20T09:36:32+00:00","insertUserID":15741,"insertUser":{"userID":15741,"name":"ker9","url":"https:\/\/community.smartsheet.com\/profile\/ker9","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-21T15:56:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-21T16:08:24+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":30,"score":null,"hot":3374465861,"url":"https:\/\/community.smartsheet.com\/discussion\/106616\/groups-how-many-users-in-a-group","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106616\/groups-how-many-users-in-a-group","format":"Rich","tagIDs":[442],"lastPost":{"discussionID":106616,"commentID":381246,"name":"Re: Groups - how many users in a group?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381246#Comment_381246","dateInserted":"2023-06-20T09:36:32+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-21T16:08:24+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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-20T11:01:39+00:00","dateAnswered":"2023-06-20T09:36:32+00:00","acceptedAnswers":[{"commentID":381246,"body":"

Hi @ker9<\/a> <\/p>

That limit is specific to bulk-uploading the emails into the group, to ensure that the request is processed successfully. I don't believe there's currently a hard limit for the number of users that can be in a group. I have seen some groups with around 10,000 contacts, if that helps. <\/p>

Cheers,<\/p>

Genevieve<\/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":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&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":5390,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势

  • 我无法使jira连接器工作

    我有一个商业账户。我是Jira的一名行政人员。没有任何东西告诉我如何连接。当我点击连接时，它告诉我联系SmartSheet。我有一个客户经理。找不到他的名字。好像也不能给我一张支持票。

  • 公式设置任务运行状况。

    你好，早上好，我有一个关于这个公式的问题。你能告诉我我做错了什么吗?谢谢你的帮助。

  • 组——一个组中有多少用户?

    帮助文件显示，您可以批量上传1000封邮件到一个群组。这是组中的最大用户数吗?我找不到说明一个组中可以有多少用户的文档。蒂雅