-
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…
-
Can COUNTIFS or COUNTIF count the number of rows based on the comparison between two date columns?
I simply just want to know the number of rows where the SD is greater than TD. The formula is actually what I got from Smartsheet's AI assistant. I think it makes sense and there is no error message, but it does not return with the correct value. So, I wonder if anyone has a solution to this? Both SD and TD columns are set…
-
How Do I Sum Up Values from One Sheet to Another With Different Criteria?
Starting with the basic of, how do I populate from one sheet to another while adding a running total? The next layer to this is, how can I get different sub sections to specifically populate into another sheet. In my photo you'll see "Parent Node F" with a total footage in bold and a delta (Production Master). In the other…
-
Issue with using formula to count rows in sheet that do not contain certain text
=COUNTIFS({All Deals Input (Master) Range 1}, $[Primary Column]@row, {All Deals Input (Master) Range 2}, [IDR In Process]$2, NOT(CONTAINS(OR("Kill but Follow", "On Hold"))) + COUNTIFS({All Deals Input (Master) Range 3}, $[Primary Column]@row, {All Deals Input (Master) Range 2}, [IDR In Process]$2, NOT(CONTAINS(OR("Kill but…