-
Counting Grandchildren Rows based on multiple criteria
Hello, I am trying to count grandchildren rows based on 2 column criteria. My parent row is different task orders and underneath are multiple children(Hospitals) and the children all each have children too (quarters). For each quarter, I need to count the number of grandchildren in that quarter that have a date in my "Date…
-
Including Contact Criteria in SUMIFS Formula
Hi! I am attempting to include a Contact Name as criteria in a SUMIFS formula. I'd like to sum Claire Robertson-Kraft's "September Actual Hours" for the "Red & Blue Exchange" project. I've written this formula (below) and it is returning the #CONTACT EXPECTED error. Does anyone have any advice on how to fix it?…
-
Is there a way to limit how many cards can be dragged into a single lane?
I have a kanban board and want to limit the number of "cards" that can be in the "WIP" lane. I also have another file where I have ABCD ranked projects, and want to limit how many can be an "A" project. is there a way to automatically achieve this? I know I can see the sum of the number on top of the lane, but is there a…
-
Capture the date in the cell when it is populated
If I would like to capture the date of a cell when an update is made, is there any way to do so without using 3rd party integration? Cannot use modified date by system as there will be more updating of data in that row. I understand that we can always put another date column to manually input the date, but just trying to…
-
Subtracting two cells and getting Invalid Operation error
Good day, I am struggling with a formula that keeps giving me an Invalid Operation error. Am I doing something wrong? Regards M
-
Can I extract the name of a column and use it in a formula?
I have a table set up with data organized by quarter (3W20, 4Q20, 1Q21, etc), and am using the quarters as the names of the columns. I have formulas in the columns that display data for that quarter, but I've had to manually type in things like "3Q20" in my SUMIFS formula for one of the criteria. Is there a way to pull out…
-
Help with Index Match bringing back Children row data based on Parent Row Match
How do I get Index/Match to do the following: Look at Source sheet column for a Match in a Parent row and if there is a match, pull in two date columns for all the CHILDREN. This formula is pulling in dates but only for the first PARENT/CHILD section. It's not checking the MATCH on the Parent Asset #. =INDEX(COLLECT({Test…
-
¿Cómo encuentro el valor de auditoria diario?
Esta es mi formula: =COUNTIFS({LAYOUT CHECK FOR DAL Range 5}, "DAL 1", {LAYOUT CHECK FOR DAL Range 6}, "Si", {LAYOUT CHECK FOR DAL Rango 2}, "14/08/20") Cuenta si en columna 5 encuentra "DAL 1" Cuenta si en columna 6 encuentra "Si" Pero como hago para que busque siempre en fecha actual, es decir con alguna función today
-
Sumifs Question
I have this formula with sumifs and I am trying to add "and is not " =COUNTIFS({Marketing WIP - Bone Pile Range 1}, "christina", {Marketing WIP - Bone Pile Range 2}, "PROPOSAL") + COUNTIFS({Marketing WIP - Bone Pile Range 1}, "christina", {Marketing WIP - Bone Pile Range 2}, "QUALIFICATIONS") I want to add and range is not…
-
Complex IF statement between two sheets with a checkbox
Hi, I am having trouble figuring out how to create a formula. I have one sheet "Step 1-Validations-CBRE" that will contain a full list of vehicle IDs and another sheet "Fleet Inspections" that will contain the submissions for vehicle inspections. Ultimately, I am trying to determine which vehicles have had inspections…