-
Summary Field that Averages Field Entries that are Less than Zero
I have a calculated field for the time over or under a deadline date. I want to create a summary field that summarizes the number of days overdue for projects completed after their deadlines. Right now I'm trying =averageif([field name]:[field name],<0,[field name]:[field name]) I get an "Invalid Operation" error when I do…
-
How to Calculate Percent Complete in Sheet Summary
My sheet is used as a task checklist for projects. It currently has a 'Status' column for each Child task with 4 dropdowns (Not Started, In Process, Complete, N/A). I am trying to create a percentage in Sheet Summary that calculates the number of fields that are marked 'Complete' in the selected cells. Pulled this formula…
-
Sheet Summary Formula
Ok I have 3 sheet summary formulas that I am trying to make into 1 formula - is this possible? =COUNTIFS([ESG Core - 4 units to pass]:[ESG Core - 4 units to pass], >=4, [Start date]:[Start date], <TODAY(-180)) =COUNTIF([Start date]:[Start date], <TODAY(-180)) =SUM(ESG# / [ESG %]#) * 100 It works as 3 but would look tidier…
-
Is there a way to weight the average in a sheet summary report?
I have a report that pulls from the sheet summaries of multiple sheets. One of the fields divides two other fields to show the % of items completed. However, when grouping & adding summaries to each column, the % completed summary averages the values below it rather than showing the actual % of items completed. In the…
-
Calculate Average of Task Progress, per Person
Hello, I am trying to create a dashboard showing the average task completion status' of a number of team members. I feel this needs to be completed in Sheet Summary, but can't figure the right formula... Essentially trying to get; AVG of Column [Status], IF Assigned to [Joe] Any clues? thanks PS. the dark rows are parent…
-
Matching Neighbor Cells or Rows to Most Recent Date
Hey All, Background: Im trying to build a fluid dashboard that tracks information coming in from a form. This form is then routed to several sheets where I break it down further based on certain criteria. I am looking for a way to report on the most recent metrics in the given sheet using the sheet summary feature to make…
-
<> in Formula
I am counting rows (projects) in my intake sheet that meet one dropdown option, but dont meet another. (I want Project Status= Site Control Initiated, but Site Control Status does not equal to SCA Signed). I created a filter on the intake sheet to quickly see these, and the count shows 223 rows. However, when I created a…
-
"Modified by " column for reports
Hello , I have a 5 reports that reads from Mastersheet . In each report I want to create "Modified by " column to capture the name of the person editing the row in the report. The same thing is for all reports. Is it possible to have many "Modified by " columns?
-
Why do some names appear with a bubble in a Contact List column and other names do not
I have a sheet with a Contact List column type called Task Owner. I also have Summary fields set up that are Contact List types. The Task Owner fields are formulas to pull from one or more of the Summary fields. Example: Row 1 has a Task Name, Task Owner, Status, % Complete, Start Date, End Date, etc. The Task Owner field…
-
How to Setup COUNT/COUNTIFS formulas
I manage the educational benefits at my job and am trying to find totals of how many dependents, drivers, and office employees participate in the benefit. This is how I've been setting up my formulas. Yet when we cross reference with Excel the total number is off. =COUNT(DISTINCT(COLLECT([Employee ID/Driver Code]:[Employee…