-
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…
-
How to count criteria in a multi-select column
I have a sheet that tracks the priority level of funding requests and I am trying to formulate a metric that 1) counts the number of requests under a particular priority level and 2) only counts the request if it is under a particular Division Group. The issue I am running into is that the priority levels are multi-select,…
-
COUNTIF reference not working
I have a time entry on one sheet where times are entered in the HH:MM (24 hr) format and another column that pulls the hour of that day. [Time Received (FORM)] - time in HH:MM format [Received Hour of Day] - pulls the hour of the day with the following formula: =IFERROR(LEFT([Time Received (FORM)]@row, FIND(":", [Time…
-
Can you use the HAS function in a COUNTIFS formula?
Based on what I read about HAS Function in the Formula Basics (HAS Function | Smartsheet Learning Center) I should be able to use HAS with COUNTIFS. When I try to use it in a sheet, I receive the error message: The formula cannot be generated because the HAS function is not supported in COUNTIFS. The formula I tried is:…
-
Need Help with IF Statement with Countif
Hi Smartsheet community. I have been working on a formula and it has not been working. Wondering if I am going about it the wrong way? I am working on a lessons learned project sheet where i am confirming if a root cause issue is being repeated or if it is new. This information is in the same sheet. My formula is below.…
-
COUNTIFS & CONTAINS (cross sheets)
Trying to count following: Any row on reference sheet in the YEAR column that is equal to "2025", CONTENT TYPE ="US" (dropdown column, single select), TEAM = "EU4" (dropdown column, single select), CRITERIA column contains "Pan-EU" (dropdown column). I have tried everything and works fine until I use Contains. I get…