使用数据穿梭导出报告
我试图在Smartsheet中使用数据穿梭设置报告的导出(将其导出到Google Sheets,以便我可以将其与我的另一个报告相结合),当我在数据穿梭中键入报告的名称时,它会找到报告,但不会让我选择它。如果我点击报告的文件夹,我找不到任何列出的报告。使用Data Shuttle导出报表是否有限制?我想只有某些列拉入一个工作表(我有太多的列和行做一个链接到一个单元格,没有办法让我做一个DataMesh,因为我将不得不基本上重新创建我从拉表)。如果有另一种方法可以引用报告,那也会起作用(但到目前为止,我还没有看到这种可能性)。
标签:
最佳答案
-
吉纳维芙P。 员工管理
正如您所发现的,目前Data Shuttle工作流只能使用工作表(而不是报表)构建。
控件中从工作表中选择特定列映射选项卡,消除任何不必要的列。你也可以设置过滤器在工作流中模拟报表上的任何过滤器。看到的:设置筛选器以控制卸载哪些行
欢呼,
吉纳维芙
答案
-
吉纳维芙P。 员工管理
正如您所发现的,目前Data Shuttle工作流只能使用工作表(而不是报表)构建。
控件中从工作表中选择特定列映射选项卡,消除任何不必要的列。你也可以设置过滤器在工作流中模拟报表上的任何过滤器。看到的:设置筛选器以控制卸载哪些行
欢呼,
吉纳维芙
-
克里斯蒂安 ✭✭
你能链接到Smartsheet吗?例如,源是一张纸,目标也是一张纸?
-
Sarah123 ✭✭✭
@Genevieve P。是否有任何方法可以设置自动导出报表,而不是手动进入要导出的报表?
-
吉纳维芙P。 员工管理
-
mmccar29 ✭
@Genevieve P。是否有任何见解,增加报告选择能力,以数据穿梭这将是如此有帮助!
-
吉纳维芙P。 员工管理
类别
It depends on your automation settings. If you set it to unrestricted, you can send to an email address in a cell without giving them access to the sheet. You can also specify which cells are provided in the update request within the automation builder.<\/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":106840,"type":"question","name":"Report not showing all rows that match the filter parameters","excerpt":"Hello! I have a sheet that has 3424 rows with a specific Due Date. When I look at that filter option in the report, I see that it sees 3424 for that field. However, when I add that parameter, only 2500 rows display. I can't find a row limit to reports that would cause this. Is there a row limit to reports that I'm unaware…","categoryID":321,"dateInserted":"2023-06-23T16:50:36+00:00","dateUpdated":null,"dateLastComment":"2023-06-23T17:36:10+00:00","insertUserID":74136,"insertUser":{"userID":74136,"name":"asimcock","url":"https:\/\/community.smartsheet.com\/profile\/asimcock","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T17:45:49+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-23T19:11:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":33,"score":null,"hot":3375083206,"url":"https:\/\/community.smartsheet.com\/discussion\/106840\/report-not-showing-all-rows-that-match-the-filter-parameters","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106840\/report-not-showing-all-rows-that-match-the-filter-parameters","format":"Rich","tagIDs":[265],"lastPost":{"discussionID":106840,"commentID":382043,"name":"Re: Report not showing all rows that match the filter parameters","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382043#Comment_382043","dateInserted":"2023-06-23T17:36:10+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-23T19:11:32+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-23T17:47:12+00:00","dateAnswered":"2023-06-23T17:02:03+00:00","acceptedAnswers":[{"commentID":382031,"body":"
See this article. There is a 2500 row limit for reports.<\/p>