-
Smartsheet at- risk formula
Hi all, I'm having a little trouble with creating the right formula for my "at risk" / "attn" column. I only want the column to flag is the status is not complete and the target end date is past due. My current formula is =IF(AND(Status301 <> "Complete", [Target End Date]301 <= TODAY()), 1, 0) Currently, the column flags…
-
Dashboard custom error message
Is there a way to create a custom message on a dashboard if criteria isn't met? One of my dashboard reports is set to the "Current User" filter. The problem is, if the current user doesn't have anything, the widget just shows an error instead of either a blank report or a better message to help the user out a little. Is…
-
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.…