-
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 &…
-
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?
-
Report Type Indicator
It would be great if there was a clear, obvious indicator somewhere on an existing report of whether it's a Row Report or a Sheet Summary Report. Currently, the only time that distinction is expressly stated is when you create the report and have to pick one. For advanced users, it's generally clear what kind of report it…
-
Seat Type Report to show Owner Status
The Seat Type Report currently displays Owners 'highest permission given on asset' as Admins - it doesn't specify they are an item owner anywhere. It would be helpful for Sys Admins trying to evaluate their end users' use of the tool if we could see the different permission levels down to Owner vs Admin in this report.…