-
Calculating 2 criteria from one column up to a specific date, also including a check box reference
I'm trying to calculate data from a status column that has drop down options of 'in progress' and 'not started' and see how many from those 2 criteria return an end date up to the end of June 2024 (working days will be 28 June). Also ensuring that a check box for if it's being reported is checked. I'm using a sheet…
-
Countifs
We are trying to build our dashboard and I want a total number of “Deliverables” across five sheets but looking at a column counting where Deliverables is listed and I can't seem to get the formula right and I can't seem to pull in a specific field from a report. See test formula (across two sheets) and I keep getting…
-
CountIF Series of Checkboxes, up to last unchecked box
Hello, I have a sheet with a series of 6 check boxes for different tasks. A team-member checks a box when an operation/task is complete. Some tasks can be done concurrently and are not dependent on another, but I would like to indicate the last completed task up until the next blank check box. Example 1: Checkboxes 1-4 are…
-
COUNTIF Formula with 2 Criteria - Status & Checkbox
Hi, I am trying to create a summary sheet from a detailed project schedule and would to create a COUNTIF formula that adds to the countif sum if the row status column is "complete" and the internal milestone column is checked; however, I am receiving an #UNPARSEABLE error and not sure what the issue is. Here is my formula:…
-
COUNTIFS formula question
I'm trying to count items on a sheet if they meet a certain criteria and contain a name and put that value on a different sheet. I'm using this formula =COUNTIFS({MT Rollup Sheet IT Lead}, CONTAINS($Label@row), AND {MT Rollup Sheet Project Status}, "Active") and receive an UNPARSED error. I want to count how many active…
-
COUNTIFS with 3 ranges
I am creating Dashboard Metrics based on Status information in a sheet. The sheet has a Status Column, Parent Status Column and a helper Column "Parent" that is Zero if it has children records or if it has no children records. If I use the below formula, my result is 2, which is correct for the "Status" column:…
-
Counting Formula Help
Hi, I am looking for a formula that counts that instances that a particular department was listed. In my scenario, Person 1 & Person 2 belong to the same department. Current formula I am using is Attendances by Person 1 + Attendances by Person 2 which gives me a result of 6 however, since they are from the same department,…
-
COUNTIFS Issue
Hi all - I am creating a calculation sheet that reference a ticket intake smart sheet. I want to use this calculation sheet to count based on the country that submitted it and what the status of the ticket is. Complete = Complete Open = Not Started, In Progress, Blocked Reference intake sheet: I keep getting #UNPARSEABLE…
-
Count Children Specific Year
Hi! I keep receiving the "unparsable" error when trying to Count from Children (sub rows) for a specific year. Current formula entering is =COUNT(CHILDREN([Alliance Partner(s)]@row), ([AM/PM Years Active]@row, = 2024)) Note: AM/PM Years Active column is a multi-select for the years active for those rows/subrows. Any advice…
-
Using Countifs Formulas to Count Number of Dates in a Date Range
Hello - Hoping for some help on my formula below. I am trying to count the number of dates (at a specific location) that are between 30 and 60 days from today. Here is my current formula: =COUNTIFS({BTP MASTER 2024 Range 1}, [Location Name]@row, {BTP MASTER 2024 Range 3}, "",{BTPMASTER 2024 Range 4}, <TODAY(+60), {BTP…