-
How to Sum Across Multiple Sheets?
Hi, I have six sheets with an identical setup. I want to be able to summarize how much Effort each person has been assigned for all the sheets. For example, Bugs Bunny may have 12 hours assigned in Sheet 1, 4 hours in Sheet 3, and 24 in Sheet 5 for a grand total of 40. I want to be able to summarize total Effort for each…
-
Combined Report of Sheet Names
Is there a simple, easy way to get a report that just has the links to the different sheets (using the Sheet Name column) that have been added to it? I've done this before with my own sheets where I filter to something consistent in each sheet (ex., I use the ancestors and hierarchy in all of my sheets so I can just pull…
-
Controlling record visibility in reports using Smartsheet Groups
This solution allows you to combine the "Current User" filter and Smartsheet Group membership to filter records based on who is a member of a Smartsheet Group. Solution overview Python Create scheduled task to run daily Python script that pulls all Smartsheet groups and group members and saves as CSV on SharePoint site.…
-
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…
-
How can I keep my grouping and summaries when exporting a report?
When I go to export my report as an excel or PDF, it does not carry any of the summaries and grouping. How can I fix this or work around this? Here is an example of my report vs what exported ( a portion)
-
Exporting Report's with Grouping
I have researched that currently we cannot export to pdf or excel in the grouping format that it shows in the Report. I have noticed that this has been discussed and mentioned for a few years but little information or anything to suggest it is actually being worked on. When will this be updated/timeline? As I unfortunately…
-
Alpha order or Sheet Order Column List
When working with columns, such as creating a report or Dynamic View, it would be beneficial to have a choice when designing to either add all columns in alpha order or add all columns in the order they appear in the source sheet. Currently, you have to add them one by one and scroll through the alpha list to put them in…
-
Export formula to Excel
I am trying to export a budget sheet that has formulas to Excel and still have the ability to manipuate the numbers with the same formula, but it does not carry the formula with the export. Is there a way to preserve that formula during export? or is there some other way to export the data and keep access to the original…
-
Merged: Report Builder - toggle column list order
This discussion has been merged.
-
Admin Center | Reporting Enhancements with Filters and Data Selection
It would be great for Admins to be able to create customized reporting through the Admin Center. Ideally, it would be a dream to bring in different types of data and filters - that way you can run a report for exactly what you need. If you have used many ERP reporting solutions, you have this option to drag and drop in…