Countif
Discussion List
- I have a sheet that collects a significant amount of data from Update Request workflows, and I am trying to develop a metric that shows all entries that have aged more than 15 days. I have a Date the …
- 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, …
- 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 anot…
- =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…
- 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 s…
- 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 ty…
- 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 c…
- 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)…
- 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
- 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 …
