-
Help With If Count If to Identify Unique Values in a Column
I'm trying to make a helper column to identify if a new/unique project code has been entered in a column so that I know when a new project has been created. I've been trying to set up this formula and plan to then set up an automation to be notified when "New Project Code" has been entered into a cell. It seems to be ok on…
-
Formula in Sheet Summary returns different count result than filter
I am trying to count new entries in a list added during the previous week. If I filter data on "Create Date" between the dates for Sun-Sat last week (eg 8/3/2025 and 8/9/2025) I get result A (65). In my sheet summary I used this formula: =COUNTIF([Create Date]:[Create Date], IFERROR(WEEKNUMBER(@cell ), 0) =…
-
CountIF <> "#NO MATCH"
I'm using the Linked Columns tool and every unmatched result is returning #NO MATCH. This wouldn't be a problem except I have a formula that counts the number of columns with a value and checks this against the expected number of values to determine row status. My previous Count(columnA:columnZ) doesn't work, and I've now…
-
COUNTIFS + FIND FORMULA
Hi I need help with the below formula please? I would like to return values that have Triage, ARB Approval, Business Case, FinRev Approval and CIC Approval selected =COUNTIFS({Tech Lead}, FIND(Metric@row , @cell ) > 0, {Intake Status}, FIND("Triage, ARB Approval Buisness Case FinRev Approval CIC Approval", @cell ) > 0)…
-
Countifs between 2 dates with status
Within Sheet Summary I can't get this formula to work, it keeps saying invalid value. Any help would be greatly appreciated. I am attempting to create a dashboard for items I have being completed on time or not using "0" or "1" through other formulas within the sheet. For example, looking for the number of CPAs completed…
-
How to use a nested if with count
We would like to have all the criteria for a created date by week. the number of new helpdesk tickets created by each end user for a given week. Example: Week of 7/7/25 Mickey submitted 5 tickets, Donald Duck submitted 10 tickets, part of Donalds 10 tickets only 5 were reported in week 7/7/25. Report Week of 7/7: Name:…
-
Formula Range
Hello Community, Is there a way to make the range for a formula start at a certain row and then continue on once other rows are created? I've found that leaving the end of range number blank or putting a future number row that has not been created causes the formula to be Unparseable.
-
Help w/ Countifs for multi-select drop down field
Hi, I am trying to use the following countif on a RAID log where the 'impacted validation report' (RAID Log - Template Range 1) is a multi-select drop down field. I cannot get the formula to return anything but 0 when I know there are outstanding issues in each different status. This is the raid log and formula. Each…
-
Merging CountIFS and Contains
Hi all, Trying to get a CountIFS statement to count when a column contains the values "UE" where another column contains a certain animal type. In the example below, the value should be 2, not 0. What am I missing or am I trying to combine the wrong types of formulas? Thank you in advance! Current formula: =COUNTIFS([Study…
-
Counting Children Rows if marked as Active
Hello, I am trying to list the number of projects (AKA children rows that are marked as "Active" under Active Project/Staff) in the Number of Projects column. The formula I am using where I get #unparseable is =COUNTIF(Children([Active Project/Staff]@row ), CHILDREN([Active Project/Staff]@row = "Active"))
-
Checking multiple sheets for duplicates
Hi, I have a workspace that is being used for uploading new information by a group of techs. This information is checked and then uploaded a database by another team. Currently, I have the sheet working to check duplicates within one sheet, but once the data is uploaded to the database the line is moved to another…
-
CountIFS contact is in a contact list
=COUNTIFS({TEST Range 1}, ="*Name*", {TEST Range 6}, ="DO") Hi all, this is a helper sheet used to get the counts of different conditions. Test Range 1 is a contact list that can contain multiple contacts, how can i make it so that i can check if "Name" is in the list. It is currently returning 0 when it should be finding…
-
COUNTIFS with Multiple acceptable values for each range
I am trying to determine the correct syntax for a query that is looking for acceptable lists of values across two columns. I need a count of all rows that have one of three values in Column A and one of 33 values in Column B. How would I format that?
-
Troubleshooting COUNTIFS with Multiple Criteria
Hi there, I'm looking for some help with a formula. I'm trying to count the number of items labeled as "THD Resource" that are also marked as "Requested." Here’s the formula I’m using: =COUNTIFS({TBD RMT Range 3}, "THD Resource", {TBD Range 1}, "Requested") But I’m getting an #INVALID REF error. Am I missing something,…
-
Calculating a percentage based on YTD wins
Hi everyone - I'm trying to add a percentage of wins to a dashboard. Initially I thought the easiest solution would be to add a formula to the sheet summary page and i used this but have been getting back #invalid Data Type error. =COUNTIFS([Status/Conclusion]:[Status/Conclusion], "Won", YEAR([Date Requested]:[Date…
-
Check if a moratorium date falls on the range between Start Date and End Date
I have a list of moratorium dates. I want to confirm if the Start to End Date for each task range falls on a moratorium date. I used this formula and it's unparseable. =COUNTIF([Moratorium Date]:[Moratorium Date], >=[Start Date]@row) AND COUNTIF([Moratorium Date]:[Moratorium Date], <=[End Date]@row) When I test the first…
-
I want to know the formula, if I want the total breakdowns from 1/1/2025?
In my sheet, I have a "Job" column, where it indicates if it was a breakdown or installation. I have a "Date of Job" column, but this goes from 2022. My goal is to calculate the total breakdowns for every year.
-
Boolean Expected
=COUNTIFS({Client Name/Planter Location}, Client@row, {Bed Plants (Early Spring)}, 1) I'm trying to match a name on a current sheet with that on another sheet; and on the other sheet, the name may appear multiple times with one or more checked boxes under Bed Plants Early spring. The results are: a box gets checked or i…
-
Boolean Expected
=COUNTIFS({Client Name/Planter Location}, Client@row, {Bed Plants (Early Spring)}, 1) I'm trying to match a name on a current sheet with that on another sheet; and on the other sheet, the name may appear multiple times with one or more checked boxes under Bed Plants Early spring. The results are: a box gets checked or i…
-
COUNTIFS Struggle – Need a Hand!
Hi everyone! I'm looking for some help with a COUNTIFS formula. I'm trying to count how many contractors vs. employees we have on a sheet. Counting employees was straightforward since there's only one type. However, there are multiple types of contractors, and I'm not sure how to count all of them together. I've attached…