-
Only Show Tasks with Completed Predecessors in Report
Hey folks. We have a number of projects with the right dependencies set up. We have reports for all our people to use. However, they're seeing tasks before those task's predecessors are complete. That's causing them to start tasks before the tasks are ready to be started. Is there a way to only show tasks with predecessors…
-
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…
