-
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:…
-
Counting Check Boxes
I am trying to count the number of records that meet specific criteria and have a checkbox checked. =COUNTIFS({Evaluation}, "1", {Resources}, CONTAINS("Scenario 2", @cell)) {Evaluation} is a column type of check box {Resources} is a column type of dropdown When I separate the two ranges and criteria into separate…
-
Help with translating text values into numeric values for graphs
Hello! I'm trying to create three (3) graphs with data we're keeping in a Sheet to go onto a Dashboard. There are 3 Teams that will each be one of the graphs, and then the data comes from a dropdown column and each option will be a bar on the graph. I'm having a hard time separating the data first by team and then second…
-
Counting rows with a checkbox
Hi I am trying to count the number of records that meet a certain criteria and has checked checkbox. The formula I am trying is: =COUNTIFS({Evaluation}, "1", {Resources}, CONTAINS("Scenario 2", @cell)) {Evaluation} is a column that uses check boxes {Resources} is a column that uses dropdown selections I want to count the…
-
Using COUNTIFS with AND in Summary Sheet
Current Formula is for # Enrolled =COUNTIFS(Enrolled:Enrolled, 1, [Course Name]:[Course Name], "Name of Course") I need a formula for Enrolled AND # Late Status Red X
-
Counting specific values in multi select cells
Hello! I've read through several different posts about which formula to use to count specific text values in a multi-select cell however, I'm still getting errors on my end. I'm trying to get a count for each virtual event my team has selected. The formulas I have tried are: =COUNTIF([Virtual Event]:[Virtual Event],…
-
Count # of Parent Rows
Just looking for a the formula to count the parent rows from the primary column. I dont need the children in this case.
-
Count IF Question - Running Count
Good Morning All, Currently have this column formula called "Count AD": =COUNTIF([Ad Name]$1:[Ad Name]@row, [Ad Name]@row) on lets say Sheet B I have the same formula on Sheet A: =COUNTIF([Creative Name]$1:[Creative Name]@row, [Creative Name]@row) Please Note: Sheet A Creative Name = Sheet B Ad Name Sheet B is generated…
-
How to get COUNTIFS to include selection within a "Dropdown List" of multiple values per cell.
Hi Smartsheet Support Community! I monitor the marketing and communications request for support log for our organization. We currently use one column to inform our team if a request needs writing, graphic design, or both. Whenever I use my COUNTIFS formula for graphic design, it isn't including the rows that have both…
-
Count non-duplicate text cells
Hello everyone 👋, I want to count the number of non-duplicate values in a column with the text type. In this case, I'd have a formula such as =COUNTIF in the [Customer Requirement]:[Customer Requirement] range to count the non-duplicate IDs. As you can see in the screenshot above, I don't want header rows (Indent Level <…