-
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…
-
Advanced Reports in Resource Management by Smartsheet now generally available!
Hi Community, We are excited to introduce "Advanced Reports," a new feature in Resource Management by Smartsheet. This release brings significant value to organizations utilizing Smartsheet and Resource Management. With "Advanced Reports," organizations can now automate their Resource Management reports—covering Time &…