-
How do I get Summary Totals to appear on the pdf attachment?
I love the enhanced report features with the grouping and summary totals. But when I send this as an attachment, they disappear? Is there a way to print and save the report to an attachment so that it presents the designed view? Thanks for your help! Sheila
-
Rolling 12-months formula: % of projects completed on time
I am looking for a formula that will calculate the % of projects completed on time when the actual complete date is on or before the scheduled complete over a rolling 12-month period and the Project Status is Completed. The rolling 12-months will be based on the Actual Complete Date column. Below is is the data. So for the…
-
How to capture time elements from a form and display on a dashboard.
Good morning Experts, I have a particular set of data that is tracking productivity with a time element reported as (hour):(minutes) AM or PM I am gathering the data in a form using text/number. Once in the sheet/grid I cannot figure out If I can or how to auto populate the results for a single time element in my sheet…
-
Sheet Summary CountIFS + Date Range
Hi All, Need some assistance. Found a great post & this on the subject but was not able to get my formulas to work. Hoping the group can help. I have 1 working the other is not. Background: Form was converted over from Google Form/Sheets & several formatting changes had to be made in August. (Probably issue #1) Co-workers…
-
Show top 10 schools on dashboard based on number of active students at each in datasheet
Been playing around for a while and haven't been able to sort....I have a datasheet with a bunch of data associated with a list of students, including the school they attend and whether they are currently active, graduated etc. I am looking to build a dashboard widget that shows the top X schools by count of active…
-
Gannt Chart in Dashboard
I have a dashboard that I've created that is pulling in a report that looks at key activities and dates from a project plan. It is a Gannt chart so users can get the visual of the project status. The problem I'm running into is that the Gantt chart is being displayed with the earliest date/data from the report. I scroll to…
-
Multi-Project Dashboards
I'm maintaining some multi-project dashboards and running into some problems with dynamic cells. Currently we have "Metrics" documents for each project. These documents contain cells that link to our timeline documents. For example: A cell may contain Phase I Health Status - and the cell value links to the Phase I health…
-
Variance on task list
I have a sheet that is a running list of tasks that gets added to weekly. I am looking to figure out how to show how early, or late, a task is completed in relation to the due date. If the task is on time, I want to show 0. I have been trying to use this formula =NETWORKDAYS([Due Date]@row, [Actual Finish]@row) - 1 This…
-
Countifs plus a date range?
Hello, My sheet has a column with due dates across the year. I would like to count how many are due each month for a forecast report to show # due in Jan, # due in Feb, etc. How do I write the formula for the date so that it includes all days of each month? =Countifs [Adjusted Due date]:[Adjusted Due Date],…
-
Displaying parent rows only in a report
I would like to display the highlighted (yellow) information (parent rows) in a report only. The current report is pulling in both parent and children rows. I would like the report to display the conditional formatting from the sheet, as well.