-
GOV - Grouping in reports
How about adding the grouping feature for reports to the Gov platform just like you have in your commercial one? This is a basic feature in most any reporting system yet you have decided not to offer it in Government.
-
Using an alias to pull together data from two sheets that have different column titles only
It would be very useful to be able to tell a report that a column labeled "Assigned To" in one sheet and a column Labeled "Responsible Party" in another sheet represents the same information for reporting purposes. I can't see this as a feature suggestion based on how I was searching for it, but I did see an abundance of…
-
Saving report view as default
I have created a report to report out from 36 sheets and have it filtered to show only one department. I would like this report view to be saved and shared with the department. Is there a way to save this view as the default when opening the report?
-
Report with Multiselect Contact Field
I'm playing around with reports as I'm new with it and in our smartsheet we have a contact field for assignments. This field is a multivalue option as there is a manager who on certain items gets assigned as well for visibility. However, when trying to create a report and filter on the number of rows per assigned person…
-
Content in a report not visible to other viewers
I've set up a report showing key milestones of various projects. I can see the report with the content that I've specified, however, when I share the report with users that have Smartsheet access, they can access the report, but they don't see any of the content. However, they do see the same report content in a dashboard…
-
How to capture the value (end result) of a formula for use in other processes
I've got formulas that return a result of a specific number depending on different keywords in certain cells on the spreadsheet. That's fine - they all work great! My problem is that I'd like to use those numbers (the end result) in other spaces in order to calculate totals for certain programs, by month and by year. But…
-
Report Date Sorting - Out of Order
Some of my report dates are sorting out of order, does anyone know why? Master Sheet 1: Dates in a column, both 2024 and 2025 data; Column Type = Date; All reports sort correctly Master Sheet 2: Dates in a column, populated by JOIN(COLLECT), cell formula; Column Type = Date; Master Sheet 2, Related Reports: Sort by "Store…
-
Using Sheet Summary for Duration and Want to Color Code in Reporting?
We are using sheet summary to show how long each project is in each phase by using =duration1 (or whatever the line number is). My question is - is there a way to color code it a certain color if the phase is still in progress, or on hold, etc, but we have moved to a new phase and it then shows a certain color then in…
-
Auto populate cell based on contents in two other cells in the same sheet
Hello - I've created a intake form to populate a sheet senior management will use for their assigned markets. Management has requested a link in the sheet to a report based on the contents in "Action Plan" (Yes) and "Market" (dropdown with 40+ city names). The manager would use the link to view the report without having to…
-
Merged: Allow users to export a report from a WorkApp
This discussion has been merged.