-
Count the total # cells with a specific word in a filtered column?
I have a COUNTIF but it is retruning a value that represents the entire sheet and not just the number of cells on the filtered sheet. Is it possible to restrict the formula to the filtered sheet only?
-
COUNTIF 2 Ranges
I am getting a #INCORRECTARGUMENT on this, what did I do wrong? =COUNTIFS({Range 4}, "xxx", {Range 7}, "xxx")
-
Formula to count unique cells, no duplicates, AND total only by an identifier
Hi all, I have three columns. One column has a program name (identifier) One column has an identification number (100020000) One column has a time span (spring, summer, fall, winter) I only want to count the identification number once and attribute it to the program name, so I am trying to work out a formula:…
-
How to calculate NPS Score from Smartsheet Sheet
Hello, I have tried to calculate our NPS score, but am getting either UNPARSEABLE or 0. What am I doing wrong here? I've tried this formula (NPS Score 1): And this one (NPS Score 2):
-
Formula column that counts the number of rows. Each row having its own number
The issue I am trying to resolve is that when the sheet has 500 rows i want automation to move a number of them elsewhere. lets say i want to move everything numbered from 350- 500. so i need each row to know how many rows there are so i can add automation so over 350 move rows. the problem i am having is i cant use…
-
Count a person from 2 different grids and drop-down vs text box?
Greetings, I'm trying to figure out if there is a way to count a person if they show up in two different sheets with two different selection options. For example, user Amanda Perry could be on sheet 1 listed under the programmer column from a drop-down where the user is only able to select one programmer. User Amanda Perry…
-
COUNTIF Error
I am trying to count the number of submissions that came from the US in the first quarter, but the formula keeps failing. Any ideas? =COUNTIF(({2024 Range 4}, "United States") + COUNTIF({2024 Range 4}, "US") + COUNTIF({2024 Range 4}, "USA") AND(COUNTIF({2024 Range 1}, "1Q")))
-
Trouble with COUNTIF CONTAINS Formula
Hi there, I'm trying to build a summary sheet with formulas that COUNTIF cells in a column on another sheet CONTAIN a specific value (this column is multiselect dropdown). I've come up with things like the following, but am still getting errors. COUNTIFS({DCYF Impacts}:{DCYF Impacts}, CONTAINS("ASD - Administrative…
-
How to count how many times an specific name in a column has a "Pass" in another column?
Hello community, I have a Calculation sheet and I want to track how many times specific names have a "Pass" and or "Fail" in another sheet. I have a dashboard I'm connecting this calculation sheet to. For example how many "Pass" in column 2 does "john" in column 1 have
-
Cross sheet reference - count with multiple parameters
Hello all, I'm looking for advice to write a cross-sheet reference formula. I have two sheets: one list of all students who have completed internships, and a second sheet with a list of organizations where our students have interned. I'd like to pull in a count of how many students interned at a particular site in a…
