- HELP Needed! Dashboard not printing
Hi All, My dashboards are not printing to pdf in total. It is only printing 1 out of 10 pages but is also including scroll bars to the right and at the bottom of the page. I have tried, Chrome, Edge, a different laptop, a different colleague, and it's still the same. I have attached a pic (document content deleted) showing…
- Metrics: Using the metrics template and metadata
I have the following setup: An Individual Project (Individual) A Dashboard Rolling Up Projects Assigned to an Individual (Program) A Dashboard Rolling Up All Projects (Portfolio) Each of the Individual, Program, and Portfolio has a metadata report and a metrics report Problem: I have to manually link the portfolio,…
- Filter only children row when certain criteria is met.
Hello Community, What I am trying to do here is to display the milestones achieved by each client. The milestones are contained in children rows. The way to identify those milestones would be displaying the row with the highest date within its own family group and box check checked. Once I am able to filter the rows that…
- How do you fix a missing reference?
Using the PMO template, I keep running into errors where my references are broke or incorrect. For example, on my Portfolio Metrics sheet, my references should be listed like below. Instead I only have Project ID. My formula is the same. How do I get back the missing references of Portfolio Summary Data and Portfolio…
- Using Contact List data in IF statement in Sheet Summary
I'm working on a system of sheets to track requisitions within our Talent Acquisition team. I've built out a helper sheet designed to help us track the average requisition priority ranking that each recruiter has. Since this is a helper sheet, its only purpose is to gather this metric, so I don't care what the sheet looks…
- Customer Survey and NPS Scoring
I have set up of customer survey that includes an NPS question. I am not too familiar with reporting and dashboards yet, so I am having a difficult time envisioning where I should do my NPS calculations ie. Intake sheet, separate sheet, report, etc. This is also my first "solution" build. Currently, I am putting the…
- Dashboard report not showing in Desktop
我有一个报告在甘特看来,not showing in a dashboard online. I'm using Chrome to access. The source sheet, report, and dashboard all are published with read only full permissions. When I pull up the website in view only using the public link, I get the the following... Is there a workaround so that the report…
- How do I create a search function in a sheet?
Hi all, I was wondering if there's a way to create a search function in a sheet or on a dashboard where it will draw specific columns for that material from another sheet. I don't want to share the master sheet with the audience. Thanks =)
- Can Projects added in Resource Management be automatically on a Smartsheet report?
Hi there, We have a custom solution build where we provision projects through a SCC blueprint, providing us a project toolkit and automated link to Resource Management with capacity integration. I am wondering, is it possible to have this also work the opposite way where we create the project in Resource management and…
- Is there a way to Add Filters to Pivot Tables?
Hi - I'm in the process of creating a "Request Tracker" sheet with associated reports & pivots to serve up to a dashboard. I want to create a pie chart that breaks down "Request Type" but only for open requests (meaning, the Status is not one of "Completed" or "Cancelled"). So my question is, is there a way for me to…
