-
Count values in a column or Pivot table
Hello, I don't have a pivot table app so I am looking for formula help. I have a grid that has a column called "Goal". Users and choose a value from the drop down or type in their own value in this field. I need to be able to generate a pie chart that shows the number of times each value shows up in that field. For…
-
Countifs Multi-select Contact
Hi Everyone, I have a sheet that contains a list of projects. In the sheet I have a column that is setup as a contact column and allows multiple contacts (Project Managers) and a column for project state (State). In my statistic sheet I list all of my project managers(ITPMO ProjectManager) and I want to look back into the…
-
COUNTIFS a range with multiple assigned groups
Hello all, I am trying to COUNTIF a range that includes multiple assigned groups in some cells. I would like to count rows that include "Dept 1". There is one row in particular that contains two assigned groups - "Dept 1" and "Dept 2" - that is not being counted This is my formula: =COUNTIF({Sheet Range 4 - Department},…
-
Just want the checkbox to check if the date is past due
Hi All, I've got a basic spreadsheet that I need the have the "complete" box automatically check itself if the due date is 1 day past due. I know I can do this with an =IF formula, I just can't figure out how. Can someone help? Best!
-
Return the NETWORKDAYS of 1 month of a 2-month duration
The goal is to count the number of days that an Employee is not assigned work within a given month (MONTH A, MONTH B, etc). For example, a given month has 23 working days; I could use NETWORKDAYS of the duration to count the assigned days of that Task; say 19. To reach my goal, I would simply subract the NETWORKDAYS from…
-
Formula Needed for Parent to Inherit Child Value
I don't think this is possible, but I need a formula where a parent row Status value reads "No Active Projects" until it has a child row below it with an "In Progress" status at which point the cell should just be blank. See image below. I use the "No Active Projects" marker to determine whether or not that department…
-
Unique list of values w/ VLOOKUP or INDEX/MATCH not working
I am trying to use the aforementioned functions to crate a list of unique values by referencing a separate sheet. The source sheet contains a column of date values and a column of checkboxes which indicate unique dates. using either functions indicates #NO MATCHES which is incorrect. Please let me know how to make this…
-
Sum based on drop downs across multiple sheets
I have multiple sheets that all lead to a "Totals" sheet on the first sheet. This project is based on caseloads in a school system. Each "sheet" is its own school in the system. I have a drop-down on each sheet for the speech teacher for that school, as well as total hours of service time needed at each school/week. I need…
-
Formula off multiple columns
I'm trying to build a formula that works off multiple columns to give one of the 6 state pain scale results (No pain -- extreme pain). Here's my formula:IF(Cancel@row = 1, "No Pain", IF(Suggested@row = 1, "No Pain", IF(TODAY() - [Date Requested by School]@row > 14, "Extreme", IF(ISBLANK([Airline Contract Attached to…
-
Countif but only if?
So I am trying to count the number of times a person worked on a specific task. I have various "types", each person might have worked on the task in a different role (Lead SME, SME 2, SME 3), and then I have a check mark whether or not it should be included in the "tally". Ultimately, what I am trying to do would be if the…
