-
Get a Countif on values in a multi-select column of cells
I am trying to write summary formulas to determine how many values appear of each in the drop-down of a column. I tried adding a wildcard, I have tried HAS, and tried CONTAIN, but I'm still not getting the right values. Currently I am getting 0 as a return value on this formula: =COUNTIF([ROI Type]:[ROI Type], HAS([ROI…
-
Countifs formula not returning a value.
Challenge: Countifs formula is not returning a value from a cross sheet. Any help would be so greatly appreciated. Summary: I am trying to pull in counts for a specific month and status for an application. The formula doesn't state any errors but it doesn't return the values. Formula: =COUNTIFS($Name18, {Status}, [JAN…
-
Formula for a Countif in the last year
I am working on pulling historical data from another source sheet but I only want to evaluate the data within the last year. I am having problems with getting the formula to pull information. I am attempting to count completed projects that were ordered in this calendar year. The idea would be to take this concept and use…
-
Countifs + Distinct + Contains
Looking for some help folks if anyone has any ideas I have a grid of marketing content by market, some of which are the same content in different languages. I want to count the content types by market but only unique content, i.e. I dont want to count the same piece of content in all languages. I've tried this -…
-
Perform Count on "Year-Mon" extracted from Created Date
I have a working sheet that utilises the Created Date functionality by Smartsheet (DD-MM-YY HH:MM). I am looking to count the number of rows for every Month in a separate sheet to see new rows added over time. to extract the year-month i have created 3 additional columns: Year (=YEAR(Created@row) Month (=MONTH(Created@row)…
-
Countif with Multiple Criteria
I am trying to get a count if VP = "Name" and Indent Level is not 0 AND an additional column does not contain "payments". My formula is: =COUNTIFS({NEW Client Onboarding Spreadsheet Range 1}, ="Sam Moses", {NEW Client Onboarding Spreadsheet Range 4}, <>"Payments", {NEW Client Onboarding Spreadsheet Range 2}, <>0) However,…
-
COUNTIF
I am trying to COUNTIF range 1 is yes then range 2 meets any of 3 criteria. A single criteria works =COUNTIFS([Current Status]:[Current Status], "Active", [Milestone/Deliverable Name]:[Milestone/Deliverable Name], "Parent Project") I need to add two additional criteria for the same second range. I want it to also count if…
-
COUNTIF "Submitted" and ISDATE = 2024
Hello! I'm receiving #INCORRECT ARGUMENT for a formula and wanted to see if anyone could help me. =COUNTIF({IPR Range 6}, CONTAINS("Submitted", @cell), ISDATE({IPR Range 4}), YEAR(@cell ) = 2024) To provide background, I have a list of form submissions (IPRs) that are either in "submitted", "approved", or "declined" status…
-
Countif a name from a list of multiple names
Greetings- I need formula help to count a name EMMA that is selected from a drop-down that has other names selected as well. Basically I need to county if Emma's name is listed in the Education Naturalist column that has other names included in the same cell. If I use =COUNTIF({Program Survey Range 1}, "Emma") it will only…
-
Formula help wanted
I'm trying to return a count of the number of cells that a) have a specific issue type and b) have an issue date within the last 7 days (I also want to duplicate the formula for 14, 30 and 90 days). I'm fairly new to smartsheets and formulas and I can't figure this out. I've managed the total count (i.e. the total count of…
