-
How to Get Pie Chart to Show Total Complete VS. Incomplete
I feel like I am getting close to this one, but something is still not working out. I just want a simple Pie Chart to show total Complete Vs. Total Incomplete. I have tried using several different columns and strategies, and although this should be easy, it is not clicking… Here is how I have it displayed now… and also a…
-
Edit reports on a dashboard
Request We need an option for the report widget that would allow users to edit report rows while viewing them in the dashboard. The problem I'm trying to solve: I have a report widget on a dashboard that shows users their assigned tasks. I'm using the widget on a Dashboard to give the users one place where they can see and…
-
Allow Data Shuttle to use reports to offload data
Hi, I have a Dynamic report that gathers information from the same sheet across a number of projects and displays the lines that meet a certain filter criteria. Currently I have to export this to an excel file and add it as an attachment to the sheet that I want updated by the Data shuttle workflow. It would be good to…
-
Adjusting formula for created Row# to not begin from 1 e.g. begin with 88, then 89, 90... etc.
Hi, For context I've created a report that draws from 4 sheets as a programme level plan. I encountered an issue with the predecessors not reporting clearly from source sheet. For those who haven't encountered this issue, smartsheet uses the row# to assign predecessors, hence with multiple source sheets only the amount of…
-
Provide users with the ability to Print a Grouped Report
Per the 1.5 years of queries being made, I believe there is suitable interest from the Community that Smartsheet provides the basic functionality of being able to print a Grouped Report. The system currently reverts the Report to a basic Sheet when Print is selected. This is not suitable or acceptable. We've stopped…
-
Why no Move/Copy Methods for Reports
SheetResouces has MoveSheet & CopySheet methods, why are there no MoveReport / CopyReport Methods for ReportResources in the API ??
-
Create Report Summary, Similar to Sheet Summary
There really isn't anywhere on a report to indicate what the report is about, or give instructions, or anything. It would be nice if there was a "Report Summary" very similar to the Sheet Summary functionality but for a report. Then we could add report level information for end users using the report. Even just a place to…
-
Countifs Past 90ds referencing another sheet
Hi, I am trying to make a dashboard that shows the top 10 pieces of equipment with the highest number of issues in the past 90d. I have my primary sheet that collects the data (Primary), and a reference sheet I am using to collect a count. I am just struggling to have it filter the last 90d. Showing #invalidoperation…
-
Reports Showing Blank Results for Current User Filter
I'm sure this is user error but I've been trying to figure it out on my own and coming up blank. I have a couple of reports I've created and want to show returns based on the current user who is viewing the report. I've asked different staff to test the view and they are both getting a blank screen. 😫 I'm not sure what I'm…
-
Need report that only shows fields that are NOT blank
Hi, new to Smartsheet but enjoying it so far. I'm building a report from multiple sheets that would ideally be a master list of all the rows that do not have a blank cell for one specific text/number column. The values within the column will vary widely but some will be blank, and I do not want to show the rows that are…