-
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…
-
Strange COUNTIF problem when referencing checkbox column in a different sheet
Dear Smartsheet Community, I'm observing a strange problem and not sure whether it's because I'm doing something wrong: I've used the COUNTIF function many times to count the number of checked checkboxes in a column, for example using =COUNTIF(CheckboxColumn:CheckboxColumn, TRUE) - and using the 'FALSE' equivalent to count…
-
COUNT IF + NOT CONTAIN
I am using the formula below and the NOT CONTAIN is not working. Could anyone help? COUNTIFS({Spreadsheet_1 Range 3}, "John Smith", {Spreadsheet_1 Range 1}, "In Progress", {2023 Spreadsheet_1 Range 2}, NOT(CONTAINS(@cell, Maintenance))
-
Countifs to Find Duplicates
I am trying to find if there are multiple requests for a bucket truck within a single day. I am getting an incorrect argument set when I try this formula, but I cannot figure out what is wrong with it. =COUNTIFS([Date Resource(s) Needed]:[Date Resource(s) Needed], [Date Resource(s) Needed]@row, [Bucket Type]@row, "55'…
-
Sheet Summary Formula Not Pulling All Data
Hello, I have a formula set to count how many projects are flagged within a specific function if they are listed as in progress, but the count is off and I can't figure out why it's not counting all instances. Is it because the column is allowing multiple selections in that column?
-
Count Formula
Hello I am looking for assistance with a formula as I need to count across multiple sheets. I am trying to capture the number of times a word appears. I selected the columns in which the word appears on both sheets and still not able to calculate the total. The formula I am trying to use below gives me an #Inparseable…
-
Aging Reports - Calculating Entries open more than 15 days
I have a sheet that collects a significant amount of data from Update Request workflows, and I am trying to develop a metric that shows all entries that have aged more than 15 days. I have a Date the entry is initiated and a date the entry was closed, but I'm having a hard time trying to figure out to extract that into a…
