-
COUNTIFS always returns 0
I can't get my COUNTIFS equation to work, it always just returns 0, can anybody help? =COUNTIFS([Column A]@row, "None", [Column B]@row, "None", [Column C]@row, "None", [Column D]@row, "None", [Column E]@row, "None", [Column F]@row, "None")
-
Counting multiple items in a single dropdown list
I'm tracking evaluations completed per month and in mydropdown list I have selections including: "Personal delivery" "Email" "Personal deliveryx2" (recently added) "Email x2"(recently added) Ona helper page, I was using a countif formula to count "personaldeliveries" only. But now that I want to count "personaldeliveries"…
-
Formula for Counting Parent Rows based on a specific column criteria
I need a Countif formula to count the number parent rows that have a specific column value of > 37 , and another formula to count the number of parent rows with the same specific columns value of ,+ 37. Can this be done in the Sheet Summary? The issue is I have Children rows beneath a few Parent rows and I don't want those…
-
Having Formula Troubles
Hello, I am trying to count a certain number of product types within a certain work week, both referenced in other sheets. I am able to count my work week data for all product types in one column using =COUNTIFS({Calculation - Defect Rate Run Chart Range 1}, =[Work Week]@row) I have another cell that I am trying to grab…
-
Which formula do I need if I want to count issues assigned to 2 people that are counted for each ind
Hi everyone, I am fairly new to Smartsheet and this is my first question in this community! I have an Issue Tracker where issues can be assigned to multiple people. On one of the charts on my dashboard I am showing how many Issues are assigned to each individual. I have a formula that counts if an issue is assigned to 1…
-
Counting items from a text/number field
I have some users where we set up a text field and they are pasting information from Excel into the field. The info is nicely formatted and appears to have carriage returns when I wrap the text, see below. I am wondering if there is a formula that would help me count the number of items in the cell. Thank you
-
Count the number or non-blank cells in the specific ranges for 2 groups of rows
Hi, I'm trying to count 2 ranges of rows (in the RP Opportunities column) where cells are non-blank and also matches with the value of another column (this is a drop down list column with values "RP" and "Canada") In this case I need to count only the non-blank cells if the value in the column named "queue (RE and Canada)"…
-
Need help with COUNTIFS and Count(Collect) formulas
Hi Formula Gurus, This should be straight forward but I keep getting 0 or 1. I'm looking for a count of projects do not have a Project Category of "test" and they have Year Started is 2023 (or yr 2024 in example 2) and Quarter Started is Q3 (or Q2 in example 2). The first formula below results in 0 (zero). This sheet is…
-
Count If with Symbols?
I am trying to label the overall health of my projects If all symbols on my range are green, I want the overall cell to have a green symbol. If one or more symbols on my range are yellow, I want the overall cell to have a yellow symbol. If one or more symbols on my range are red, I want the overall cell to have a red…
-
COUNTIFS, multiple selection drop down
Hi All, Ive been looking through what feels like hundreds of posts trying to find a solution for this. I'm looking for a formula to count the number of times TWO criteria (or more, for future reference) have been selected from a drop-down menu. Current: =COUNTIFS(Location:Location, HAS(@cell = "Mission Bay" + "Remote"))…