-
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.
-
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…
-
Add Sheet Summary Reports to Dynamic Reports in Control Center
Include the ability to add Sheet Summary Reports as Dynamic reports in Control Center. We keep data in the sheet summary in multiple toolkits, it would be very convenient if we were able to add a dynamic report of sheet summary fields to get a holistic view of our profile, and be able to update the sheet summary fields…
-
Row Report from Sheets in Workspace
If I have a set of folders under a workspace with different type sheets. Some will be Project plans, others may be RAID/CRAID Logs, etc. Is there a way to create a row report of all the RAID/CRAID Logs only, and separate from a similar row report with all the Project Plan line items?