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…
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 S…
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 …
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 c…
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 curre…
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 …
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 …
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 …
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…
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 cond…