-
Dashboard report not showing in Desktop
I have a report in gantt view that is 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…
-
Get Month and Year and Group/Sort
I've got a sheet in which sales reps input their daily activity. This sheet has a date column that is required. I'm trying to make a dashboard to track month to month levels of activity. Perhaps I'm missing something but there doesn't seem an obvious way to do this. I've tried making a report to group by month and sorts…
-
Help with creating a smartsheet dashboard!
Hi, I created this report showing all of the delayed tasks and tasks for the current week and upcoming week. I want to have a 3 summary charts (most likely a pie chart) with a breakdown by status, a breakdown by workstream, and a breakdown by assigned to. As the report is right now, I can't create a chart because there are…
-
Summarizing a column based on another multi select column
Hello - I have a column named "Monthly Hours" that lists hours (integers). I have another column called "Site of request" that lists the site(s). That column is multi-select. I would like to summarize hours spent per site. So, if the "Monthly Hours" column has a 10, and the "Site of request" lists "Site A" and "Site B",…
-
Formula to Capture Active Projects Assigned to an Individual ONLY
I'm currently having trouble figuring out how to capture the number of status specific projects assigned to an individual. I've attempted the "COUNTIFS" formula many times, but can't seem to configure it so that it counts the number of projects by assignee IF the project status is one of the following: Not Started In…
-
Moving rows/updating cells
I manage a portfolio of projects which I have to report on. I'm a Pro user, so I don't have the functionality that could probably make this task very easy. My project managers are required to use a company solution (not smart sheet to create project plans and updates). I've created a smart sheet that lists all of the…
-
Dashboard/Report to show status change in last 30 days
Hi, I'm looking to be able to show on a dashboard a chart and detail of projects that have had a status change (RYG) in a given period of time (last 30 days). It doesn't appear that reports allows to filter on that type of data. any suggestions? Thanks! UPDATE- solved via Automated work flow using an added date column, and…
