-
Can COUNTIFS or COUNTIF count the number of rows based on the comparison between two date columns?
I simply just want to know the number of rows where the SD is greater than TD. The formula is actually what I got from Smartsheet's AI assistant. I think it makes sense and there is no error message, but it does not return with the correct value. So, I wonder if anyone has a solution to this? Both SD and TD columns are set…
-
How Do I Sum Up Values from One Sheet to Another With Different Criteria?
Starting with the basic of, how do I populate from one sheet to another while adding a running total? The next layer to this is, how can I get different sub sections to specifically populate into another sheet. In my photo you'll see "Parent Node F" with a total footage in bold and a delta (Production Master). In the other…
-
Issue with using formula to count rows in sheet that do not contain certain text
=COUNTIFS({All Deals Input (Master) Range 1}, $[Primary Column]@row, {All Deals Input (Master) Range 2}, [IDR In Process]$2, NOT(CONTAINS(OR("Kill but Follow", "On Hold"))) + COUNTIFS({All Deals Input (Master) Range 3}, $[Primary Column]@row, {All Deals Input (Master) Range 2}, [IDR In Process]$2, NOT(CONTAINS(OR("Kill but…
-
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.
