-
Add Viewer Mode Settings to Reports
The Report widget on Dashboards has a Viewer Mode, which dictates what data viewers of the Dashboard can see - only data from sheets they have permission to view, or data from sheets that the last widget editor has permission to view. Adding the Viewer Mode with the same options to Reports would be incredibly helpful. As…
-
How can I create a helper sheet that reads totals from multiple reports
I need to create a 'helper sheet' sort of like a metrics that will collect multiple counts from multiple reports so that I can chart it easier in my dashboard. I currently have 60 reports which each have 3 counts on them, meaning that each one would need to be charted individually. I would like to be able to create a…
-
Edit Start, End, or Duration from Report
I'd like to be able to edit the Start Date, End Date, or Duration of a task from my report. At present I can only edit Start and Duration from a report because End is treated like a formula. This is problematic when I need to adjust both dates because it forces me or another user to do math (accounting for non-working…
-
Creating a report with data from 3 different sheets
Hello! I'm new to Smartsheet and I need some help building the following two reports: I have 3 sheets, with the following main collumns: Sheet 1: Open Matters, containing #Matter, Client, Matter Type Sheet 2: Invoices, containing #Matter and Amount Received (Revenue) Sheet 3: Expenses, containing #Matter, Contractor,…
-
dynamic dashboard update
Is it possible on a dashboard for a widget to be dynamically updated? In the image above the "In Progress" is "Rich Text" widget type. I want to be able to check a box (elsewhere…not on the dashboard, and based on the check box - it wouldn't say "In Progress" but it would display a report. I know i can't have a widget…
-
Removing Zero Values From Chart
I am trying to create a stacked column chart to show how many Statuses are being used per section (Section for Chart) in a project plan. However, I do not want any zero values to show. I have attempted to create a report for this chart, but I cannot get the chart to look the way that I want. What I want (minus the zero…
-
Linking Multiple Sheets in a Report
My org has a number of sheets that we were hoping to link together in a report. Two of the sheets have a primary column with the same item number (in our case, new product request number or NPR-XXXX) associated with it. On the third sheet, it has a separate identifying number for a part number request, and in some cases a…
-
Help with COUNT forumula for column with duplicate names.
Afternoon, I am creating a reporting dashboard to report employee stats. Each of the metrics on my dashboard is fed from a dashboard calculation sheet. Each of the sections in my dashboard calculation sheet references another sheet based on different criteria. In each of these sheets, i have a column with employee names…
-
Merged: Adaptive Height Report Widgets in Dashboards
This discussion has been merged.
-
Filter report to only items where comments mention specific text
I'm looking to create a report that will show me only the records where I am mentioned/tagged in the comments. This is not a comments column, we are using the standard 'comments' functionality. Would even be sufficient to just filter on any rows where the comments are like '%SomeText%'. Seems fairly similar to this post…