报告增强请求
我希望能够从单个顶级单元格引用报告的过滤条件。我的项目和解决方案/问题如下:
我从事制造业。我们的机加工生产线有很多工序，平均约有20道工序。每个操作都有一个操作员，该操作员在轮班结束时提交一份报告，报告有关该操作的15件事。这15件事对所有的操作都是一样的。
这些都是由一位经理整理的，然后分发到我们的工厂。
我想建立一个报告系统来分析历史数据，并允许方便的输入。为此，我为每个操作制作了表格和提交表格。由于行数和想要保存的历史数据量的限制，我为每个操作都做了一个表。
然后我开始分析。我们有3班，20个操作。我希望能够根据班次或操作进行分析，但我真的不想构建84个单独的视图和报告(包括所有视图)，并让用户对所有这些进行排序。我需要的是一个报表，它可以根据来自工作表级别的用户输入更改其过滤标准。(作为一般规则，除了我的同事，我不允许任何人访问我的报告，因为这产生了许多问题)
我目前的解决方案是在带有分析选项的标准表上进行一些下拉。然后，我使用工作表链接来解析数据，并给出用户选择的内容，并为每个内容留出50个位置。我很快就达到了表格引用的最大值，最终不得不使用5张表格，然后将它们合并到一个报告中。
评论
-
Shaine格林伍德 员工你好卢克,
听起来您建立了一个健壮的解决方案来获得所需的工作流。
当您有时间时，请使用社区网站右侧快速链接下的表单提交产品增强请求，并让我们的产品ob欧宝娱乐app手机下载团队确切地知道您在寻找什么。你可以提供给他们的任何材料(更多你的流程截图或任何行为流程图等)请使用表格提交，以便他们更好地理解你想要什么。
-
J.克雷格·威廉姆斯 ✭✭✭✭✭✭我也建立了一个类似于卢克在这里描述的解决方案，并遇到了同样的问题。
我重新提交了这个请求。
克雷格
类别
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/IEPF8MV8BTLQ\/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":292,"urlcode":"Dashboards","name":"Dashboards"}]},{"discussionID":106694,"type":"question","name":"SUM help","excerpt":"I am a newb with smartsheet and still learning. I am building a risk assessment tool and the form for the end user has check boxes. Each box gets a specific value based on risk. So anything from one box to all of them could be checked. I need the total of all boxes checked. Here's where I am stuck: =IF([FLIGHT PROFILE]@row…","categoryID":321,"dateInserted":"2023-06-21T14:26:08+00:00","dateUpdated":null,"dateLastComment":"2023-06-21T19:34:51+00:00","insertUserID":162593,"insertUser":{"userID":162593,"name":"BMiller828","url":"https:\/\/community.smartsheet.com\/profile\/BMiller828","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-21T20:59:56+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-21T20:00:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":21,"score":null,"hot":3374736659,"url":"https:\/\/community.smartsheet.com\/discussion\/106694\/sum-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106694\/sum-help","format":"Rich","lastPost":{"discussionID":106694,"commentID":381598,"name":"Re: SUM help","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381598#Comment_381598","dateInserted":"2023-06-21T19:34:51+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-21T20:00:08+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-21T18:42:53+00:00","dateAnswered":"2023-06-21T18:00:45+00:00","acceptedAnswers":[{"commentID":381574,"body":"
Ok. Instead of nesting your IFs together, you want to \"add\" then together and use a HAS function.<\/p>
=IF(HAS([Flight Profile]@row, \"Normal Call - In Country\"), 1, 0) + IF(HAS([Flight Profile]@row, \"Normal Call - Out of Country\"), 3, 0) + ..........................................<\/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":[]},{"discussionID":106654,"type":"question","name":"I cannot get the jira connector to work","excerpt":"I have a business account. I am an Admin in Jira. There is nothing telling me how to connect. When I click on connect it tells me to contact SmartSheet. I had an account manager. Cant find his name. Can't seem to put in a support ticket either.","categoryID":343,"dateInserted":"2023-06-20T18:25:35+00:00","dateUpdated":"2023-06-21T11:24:59+00:00","dateLastComment":"2023-06-21T12:52:23+00:00","insertUserID":159164,"insertUser":{"userID":159164,"name":"clawson","url":"https:\/\/community.smartsheet.com\/profile\/clawson","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtd8k6WqAcj3CUkjC0jOTaQM0V6AiPZO2dYG7Ihh=s96-c","dateLastActive":"2023-06-21T12:52:51+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-21T19:26:58+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":25,"score":null,"hot":3374638078,"url":"https:\/\/community.smartsheet.com\/discussion\/106654\/i-cannot-get-the-jira-connector-to-work","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106654\/i-cannot-get-the-jira-connector-to-work","format":"Rich","lastPost":{"discussionID":106654,"commentID":381467,"name":"Re: I cannot get the jira connector to work","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381467#Comment_381467","dateInserted":"2023-06-21T12:52:23+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-21T19:26:58+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-21T12:54:58+00:00","dateAnswered":"2023-06-21T12:52:23+00:00","acceptedAnswers":[{"commentID":381467,"body":"
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>
