-
Report/Dashboard Question
Hi all, I am building reports and a dashboard for the support tickets my team receives. I want to create a report and chart to show the number of tickets our clients have submitted so far this year. Since we have well over a 100 clients, there are some clients that have only submitted 1 ticket this year. I'm trying to…
-
Reports: Joining multiple sheets by column names
Let's see if I can ask this correctly. I would like to have a report pull from 2 sheets. Sheet A: Resource (Drop down of people in department), Department Name, Title Sheet B: Project Plan (Possibly plans but lets stick to 1 sheet for now), with Assigned to , Status, etc Assume I make the Resource and Assigned to the same…
-
What is the best way to make a report that pulls from a very large sheet (14K+ lines)?
My source sheet is 14K+ lines and counting. Reports are limited to 2500 lines. Even when I have broken this data down by the quarter, this report is too large to even display all the data. What is the best way to support this?
-
Merged: Merge data from 2 sheets into 1 row
This discussion has been merged.
-
Printing Grouped Reports
I have a report that i have used the new grouping function on and i'm wanting to print it with the group headings but each time i print as pdf or export it only shows the standard cells, without the group headings, is this correct or is there something i'm missing?
-
Resource Management
Is there a way to create a master agile resource tracker and link it to every other project without having resource management?
-
Analyse three columns content and produce a representation of request priority
Hi! TIA for any advice! I have a Smartsheet fed by a user form, that provides me with bookings for a service provision. As part of the service provision request in the service booking summary Smartsheet we have a department ID of the requester in one column, a "date created" column, and a column that shows the user/form…
-
User Management - Custom Job Categories
Allow entry of custom job categories. Add new fields to capture a user's business unit and department. These fields should also be included in all user reports. This functionality would be helpful for businesses that cross charge business units and depts for licenses and usage.
-
Current User Report on Dashboard - NOT SHARED
Today if you are using a Current User Report on a Dashboard you have to be shared to the source sheet. If I don't want people to see the data, there is no easy solution. Please allow the current user report to work by filtering in for view on the dashboard, not source data. Dynamic View doesn't have all the features of a…
-
Need to count project managers and number of projects
I'm hoping the smartsheet Gods can help me. I'm struggling. I have 126 projects in my sheet and about 30 different project leaders. Each project leader is set up as a contact (see 2nd screentshot - Pink) I'm trying to count projects by project lead. I'm hoping to come up with something like the first screenshot. Any ideas…