-
How do I total the answers from a drop-down cell?
I'm trying to build a dashboard that will show the progress of sites completed for an upcoming upgrade. I have attempted several ways to compile this information automatically and I'm at a loss. I think a simple cell formula might be the easiest way to accomplish what I need then I can link the cell to a report I create.…
-
Grouping and Organizing Reports
Is it possible to use grouping in reports and manually arrange those groups? For example, I have groups (Initiation, Planning, Execution, Closure, Terminated) to group phases, but then I only have options to alphabetically (ascending or descending) organize those groups; this means I can't actually get the groups into the…
-
Pivot App Zero Values
Hi All, I'm using Pivot App to summarize the number of records from a variety of reports. It works great, but if there are no records in a report, the pivot table will report blank. I was hoping for a "0" value, as I'm pushing the data in these fields as number summary in the Dashboards/Portals. Other than creating new…
-
Can I keep grouped reports colapsed?
I have a grouped report below that I expand to update individual sheets. However when I return to the report each all are expanded that I have close again to scroll down more easily!. Is there a way to keep it collapsed?
-
New Blank Report not showing fields
Hi everyone, I am trying to create a report but it does not show the columns from the sheet, am I doing something wrong? I select the sheet that I want to create the report and nothing happens, I've tried refreshing the page, refreshing the sheet and nothing.
-
Enhancement Request: Hide formulas from Viewers in Reports
A Viewer has little reason to need to see a formula in a column that is being displayed to them in a Report. Please remove the hover for the Formula (the other hover that displays the full contents (display value) of the cell is OK, just hide the formulas. Or tell me why this is a good feature.
-
Collaboration of Project Plans
Hi We are using smartsheet to manage all of our customers onboarding projects in the Professionals Services department. We have global team that share resources globally. What are the best practices we should use in order to share all projects among all team members and have reports/dashboards that will highlight project…
-
In Reports, why is group name header inconsistently different from sheet name?
I have a number of sheets in a report and the names are not showing correctly when grouped. When I check the properties for the sheet it is correct but does not show correctly when grouped. The sheets were copied as part of a folder Save As New... and renamed. from Bus Risk Register. Is there a fix for this?
-
Blueprint Reports not Connecting
I am working on a program blueprint currently and the functionality is not working how I'd expect. In this set-up, the program blueprint will get provisioned as its own workspace. I have several reports that I need to look to the workspace that it's in, in order to pull in all the project templates that we put in the…
-
Report Grouping Keeps Being Reset
Good day all, I have been have quite the issue with my reports that clients use and hope you can help. Any grouping I apply to the reports seems to undo itself after some time. I'd go back to the reports and suddenly it would be a complete mess. The sort seems to hold though. None of the clients have admin access so no one…