-
Removing Total Row from Smartsheet Reports
I am creating several reports that subtotal financial information by various groups (i.e. revenue, numerous expense categories, EBIT etc.). I do not want the reports to display a total row that sums all the revenue, expenses, and profit as this is misleading. Does the functionality exist to turn this off?
-
Report for yesterday
Hello, I hope someone can help me. Maybe I'm blind, but I can't find a way to make a Report for only yesterday, I work on a big sheet (> 4,000 rows, 25 columns) with many different days in the column [Datum]. Now I want to make a report, that shows only the rows from yesterday. Not today, not further in the past. I want to…
-
Report Sorting
I feel like this should be simple, and it's not. I am trying to sort these rows by the month in this report. It was originally sorting alphabetically, so I added the numbers in front, and that didn't change it either. Any help? Thanks!
-
Dashboard > Report Widget | Empty filters are not not being mapped, data source not kept
When creating a Report widget with a filter not matching any results, the data source is not being kept. It will show this screen (see below) : With the details pane like this: Take note that I already mapped it to the correct report and still showing like this after saving. Issue here is when a filter matches the report…
-
Can you edit a report without editing the source sheet?
Can you edit a report without editing the source sheet i.e. conditional formatting, adding columns, locking fields, and field specific notifications.
-
Adding Current Month Data To Dashboard and Metric Widgets
Hello Community, 1st Question: I am creating a dashboard for our compliance statistics. I have built out a dashboard calculation sheet based off other sheets as seen in the image below. I am looking to add only the current months lable and associated data to my dashboard to keep it clean. 2nd Question: I also have the…
-
Sheet Timeout & Performance Issues – Identical Copy Works Fine, Original Doesn’t
Hi everyone, I’m currently working with a Smartsheet that includes: ~30 conditional formatting rules ~1700 rows Multiple columns with INDEX/MATCH formulas Numerous columns with regular @cell formulas Numerous columns with various types of data Two Data Shuttle workflows that update dropdown values in two columns Multiple…
-
Center and middle justify summary fields in a report
I have created a summary field in my Smartsheet that is a formula: Overdue Tasks =COUNTIFS(Status:Status, <>"Complete", Status:Status, <>"Canceled", Finish:Finish, <TODAY()) Works just great! Returns a number that I would expect. The challenge is that when I create a row summary report that references the field Overdue…
-
Add today line to Gantt Report in Dashboards
The today line should be visible when a report is added to a dashboard in Gantt view. This is a very necessary reference point for a dashboard.
-
Current User report filter not working on Dashboard
I have created a project Homepage using a Dashboard and would like to be able to display a list of actions, risks and issues owned by the "Current User" on this dashboard. To do this, I have created reports for each of these items and, using the report builder, filtered the data to show records that have Current User in…