-
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…
-
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…
-
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,…
-
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…
-
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…
-
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…