-
Row report to show data from 2 sheets if column data matches both
I have 2 sheets with very similar, if not identical, data except each sheet is for a different year. I am looking to create a row report to show only the data if the category column matches on both sheets to compare the differences from this year to last. I already have a formula to remove the parent row from the report. I…
-
Trying to see how many projects are assigned and how many are assigned as initiative resource
I have a project sheet that I need to pull into a dashboard and show the count for each project manager that are primary then also show how many they are secondary for. I am having issues because I have multiple contacts both boxes, and need each time their name appears to count towards their total projects. Ultimately…
-
2 Reports not showing on my published dashboard
When I publish my dashboard 2 reports are stating they need to be viewed on Smartsheets. the other 3 reports have viewed no problem. They all have the same permissions levels. HTTP s://app.smartsheet.com/b/publish?EQBCT=3c11a22bbcc142df8368f9ac975c1ec4
-
Create a report from two sheets but some of the data is the same
I have two sheets that I want to merge into a report but some of the rows are in both sheets as they are either Phase 1 only, Phase 2 only or Both Phases. When they are in both Phases they are in both sheets for many reasons that I will not go into. Do I need to create 1 further sheet which only has the countries that are…
-
Multiple Duration Fields
I'm attempting to track a duration time needed for our project manager and a separate duration time needed by the customer. I want to calculate those two separately. Some tasks require time for customer only; others for the project manager; others require involvement from both. Is there a way to create two separate fields…
-
Hiding legend items that are zero
Good afternoon Sheeters! I am developing a graph from a report where it tells me which department had what kind of injuries. when I try to chart it, i end up with an insanely long legend with colors doubled up because it's showing items that have 0. How do i chart with a legend and have the null items not show in the…
-
Blank Value for Schedule Health
Hello, working with the formula below for schedule health: =IF([% Complete]@row = 1, "Blue", IF(Status@row = "Cancelled", "Blue", IF(Status@row = "On Hold", "Yellow", IF(TODAY() > [End Date]@row, "Red", IF(AND(TODAY(10) >= [End Date]@row, [% Complete]@row < 0.5), "Yellow", "Green"))))) Would like to add: If [End Date]@row…
-
Auto-Populate Master Task List
Hello, I am managing several projects for our team. Each project has its own task list and project elements. I would like to create a master task list that is a combined list of all the project task lists and I would like for it to automatically populate when there are any updates to the project tasks lists. Is there a way…
-
Issue/Help with Document Builder
We have been using the same mapping for document hander for approximately two years. Yesterday we started to have an issue where information included in the mapping isn't being pulled into a document. I checked to make sure the section is still linked to the correct column, and it is, but it still isn't pulling the…
-
Is there a way for a user to change visible data sets when viewing a Dashboard ?
Hello All, I'm new to Smartsheet and have been trying to become familiar with the basics over the last week or so. I'd like to know if within a Dashboard its possible for a user to click a graph entry (or some other graphic within the Dashboard) and for a panel within the Dashboard to display the relevant information. For…