-
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…
-
Counting number of specific selections within a dropdown list
Hello! I would like to create a formula that will allow me to count number of times a specific selection has been made from a drop down list of options (whether or not the selection was the only one selected or alongside other multi select options) As an example these are the selections in the drop down multi-select list:…