-
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.
-
Edit recipients in scheduled email reports
I have many reports that get emailed out on a defined schedule and often the recipients need edited. Unfortunately editing recipients is not an option (only editing the recurrence schedule), so I have to recreate the entire schedule to remove or add any recipients. It is very tedious and time consuming when you have…
-
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 &…
-
Group Rows in Sheet, not just in Report
I would like to view rows grouped by their category (from a dropdown column) in Sheet form, so that I can add new rows while viewing my data in an easier-to-read format. Currently it seems grouping can only be achieved in a Report which does not allow me to add new rows. I am new to SmartSheet but have intermediate…
-
Refresh Rate of Data in Admin Center Reports
I am in my first reconciliation period under the new USM. Per your recommendation, I am using the Seat Type Report and Sheet Access Report to see the activity of my users and to determine who needs to be a Member, and who should be a Viewer. The Reconciliation period is 30 days, yet the reports don't pull live data and…
-
Time Zones
Smartsheet "Reports" created dates are showing in UTC time, can this be changed to EST?