-
Anyway to change report columns to show as rows?
I have a report based on a sheet summary that I would prefer showed in rows, rather than columns - is there an easy way to do this? Ideally I would like the above sheet to show each column as a row so, when I use this in my dashboard users can scroll down rather than across as this would be the natural way to read this?
-
Is there a way to put a timeframe on when a filter works?
I am trying to create a filter in a report where is removes any tasks that are complete. Is it possible to set a filter so that it removes any tasks that are complete after they have been complete for 1 month? Or do they have to filter immediately?
-
Will there be a way to sort Grouped Reports based on the count of the grouping?
I really love the functionality to group data in a report. Additionally, I am excited when that display is supported within Dashboards. However, I'm curious if there will be the option to sort the report data based on the count of the grouping rather than a specific column? I'm treating things more like a pivot or pareto,…
-
Report sharing
Dear Smartsheet Community, Is there an estimated release date for report sharing without access to the underlying sheet? I see that this was being worked on in September or October of 2023. Thanks, Taylor
-
Team Assignment Report Help
Hello All, longtime user of Smartsheets for work - first time poster seeking help. I am search for a solution in creating a report to show all of the assigned tasks from a Smartsheet that outlines all of the Classes our Org is holding for Staff this year as sorted by assigned Training Staff. Those Training Staff are…
-
Multiple Reports on Dashboard
Anybody have any creative solutions to allow users to toggle between multiple reports on a dashboard? Essentially I want to have my main Executive Dashboard, with a Report widget that can be updated with various filters - without having to click into the report and change the criteria. I have about 20-25 different 'slices'…
-
Pull milestones from multiple projects into single sheet
Hey all! I'm managing multiple medium-large scale projects within my org, all on their own project plans, and I'm wanting to build a consolidated enterprise-wide tracker so I can see where I'm at with all my milestones in a single plan / dashboard. Is there a way / template that would allow me to pull in milestones from…
-
How to only Sum values for unique requests with a specific request type
Hello, I have created a sheet to calculate some data points based off of an archive of requests that get pulled from an Automation when Estimated Completion Date and Actual Completion Date are changed, and I am trying to setup a columns to display the Average Days to Completion for each request type to help with estimates…
-
Help with Summary report build using matching dates to sum meeting minutes used.
Good morning! I am trying to build a meeting report for my team's weekly Work In Progress (WIP) meeting. I am using a form for team members to fill out how much time they need for our one hour meeting and on which date. I have a formula that takes any matching [WIP Dates] and sums their [Time needed in minutes] The Sum of…
-
Calendar view not working on mobile
We had recently added a calendar view of a report to a portal/dashboard we released to our entire company. Reason for the report is we did not want to publish the sheet itself as a calendar to the portal being that when you right click on a date range displayed on the calendar and select "view detail" it would still show…