-
COUNTIF Formula Returns Zero in Sheet Summary
I have a very simple COUNTIF formula that isn't working in the sheet summary section. For example, I'm trying to count how many times the year "2017" appears in a column called "Tablet Year". The formula should be: =COUNTIF([Tablet Year]:[Tablet Year], 2017) I've also tried surrounding the "2017" in quotation marks in case…
-
Count Report
Hello, I have a sheet with 7 columns each indicating a different team or step in our process (UX, Content, Regulatory Review, Planning, Execution, Data, Testing). I also have around 300 rows of tasks that need to hit each team/step. All cells in the sheet begin at "Not Started" As they move through each team, the team…
-
Count checked boxes in a column from another sheet
Hi All, I am working on a dashboard that displays various info and tasks in state of completion. I'm wanting to count how may checkboxes in a column to display a chart in my dashbord showing % complete. Based on other posts I felt it was a good idea to create a helper sheet that has the formulas and reference into the main…
-
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…
