-
How do I change the columns on a task rollup report?
I'm trying to replicate the Task Rollup report that is available in the Smartsheet templates. However, for reasons I can't figure out, I'm unable to get different values for the Status column to populate the columns like the template does. Instead, it imports every task in the base file and it's respective status as rows.…
-
A few more updates to the new report builder
Hi Smartsheet Community, We’ve received a ton of feedback from you about our recent updates to reports, the report builder, and grouping & summary. We just want to say thank you - your feedback is critical to helping us deliver the best possible capabilities! Based on your feedback, we’ve made a few changes which you’ll…
-
Row limits in Reports / Grouping
I am pulling data from 2 different sheets that currently span about 5,000 rows with more to come. When I create a report looking to group the information certain ways it seems that the row limit inside the Report itself is 2,500, is that correct? When the data is grouped, I cannot uncollapse the groupings unless it is…
-
Dashboard Filters
Hi All! Can we make filters or slicers in dashboards of smartsheet to make it interactive or is it only possible to have fixed visualization?
-
Kanban style dashboard
Hello, I would like to build a kanban style dashboard from a project plan or any other sheet that contains an action/owner/status. The second step, is I can create this Dashboard to bring together actions from multiple sheets. e.g. I can have action list 01 and action list 02. Bringing them together could show me the…
-
Graphs and Charts
Hi, I am fairly new with Graphs and Charts in Smartsheet. I am trying to create a monthly operating report with different graphs. An example is a KPI trend month by month. I am stuck at the first step: I have the raw data by day. I pulled them in a report and don't know how to average by month to create the graph by month.…
-
Is there a way to update source sheets for multiple reports?
We created about 30 reports. Each of them is taking the data from multiple sheets (each sheet is a project that our team is working on.). When we add a new sheet (new project), we have to go through each report one at a time and add the new sheet to the source data in the report template. This is very time-consuming when…
-
Report not filtering out all 100% complete tasks
I have a report to show me all of the tasks that are in progress (not 100% complete) or not started within a timeframe. Therefore, the report is supposed to filter OUT all tasks that at 100% complete. It has been working for over two years, with two different schedules. But now two items won't fall off of the report (the…
-
Grouping info on reports
Hi all, I have 3 spreadsheets for which i want to report information from. All of them have common information/references (i.e. POW1234) but the name of the columns where that information is will be different from spreadsheet to spreadsheet. Is there a way to, on reports compile or group all the rows that have the same…
-
Can we create webhook on Reports like we do for Sheets
We can update the reports manually and since its bidirectional it updates the underlying sheet and vice versa. My question is whether we can create webhook on Reports or not like we create webhook for Smartsheets. If the webhook can be triggered on Reports it would be helpful for me. Please share your thoughts on this.…