-
How to count the number of times a name refrenced in a cell appears in a column
I'm trying to create an attendance tracking sheet, and different numbers of absences leads to different diciplinary measures. I know I could use COUNTIF, but there will be hundreds of employees, and I dont want to add them each individually. Is there a way to tell the formula to count the number of times the Value in the…
-
CountIFs formula question
Hi, I am trying to count the amount of time a drop down is selected within a range of columns that is in a specific location (separate column with it's own values). My goal is to count how many times Location (A-C) have the value Properly demonstrated and Not Properly Demonstrated selected. This is currently the formula I…
-
Last 7 Days
I need a formula that counts the number of requests that have been submitted within the last seven days if assigned to "John Doe". Smartsheet's AI generated this formula, however it comes back to me as #UNPARSEABLE. =COUNTIFS({Filing Submitted Date}:{Filing Submitted Date}, {Filing Submitted Date}@cell>=TODAY(-7), {LRT…
-
Count formula referencing another sheet with 2 parameters
Hello All! Need a little help- I have a formula where I need to reference another sheet and then count based on two criteria. Right now I am getting and error would love another perspective. The formula is going for if the sheet has Monthx and MonthX count. Below is what I currently have for a formula.
-
#Nested Criteria when combining formulas together
I am trying to get this formula to work, but it kicks back the nested criteria. =JOIN(DISTINCT(COLLECT([Employee Number]:[Employee Number], [Created Date]:[Created Date], IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), [Employee Number]:[Employee Number], COUNTIF([Employee Number]:[Employee Number], @cell) >= 2)), ", ") I just…
-
Count based on Multiple Criteria & Dates
Hi, I am attempting to create a formula that would = Count the number of training items completed per team member and between two dates. I created this formula, it is giving me all Zeros: =COUNTIFS([Actual End Date]:[Actual End Date], <=DATE(2024, 1, 1), [Actual End Date]:[Actual End Date], >=DATE(2024, 12, 30),…
-
Nested IF/CountIF Help
Hi! I am currently building a dashboard to show reporting on employee injuries for cases that are not resolved. I am having trouble with my formula and have been spinning my wheels. I need the formula to look at my reference data and, if the checkbox in the 'Done' column is not marked, then return the incident type into my…
-
Help with COUNTIFS
Hi Community! I am hoping someone can help me figure out how to correct this formula or create a new one. I want to count how often the regional VP’s name appears in a row with a date within a specific date range (quarter). Current formula I am using in a calculation sheet and referencing another: =COUNTIFS({TLH User…
-
Index Formula with CountIFS Running Total
Hi - trying to make a Training Matrix for my company. "Matrix" sheet has the following columns: Row: (Auto-Number) Doc ID: (Text = document needing to be trained on) Employee 1: Check Box if they need to be trained Helper: column formula to give running count of checked boxes =COUNTIFS([Employee1]:[Employee1],…
-
Percentage of check boxes - Need to exclude blank cells
Hello! I am working on a formula to calculate the percentage of boxes checked. This formula is currently working when I set the range to exclude the blank cells. However, I need to allow space for more rows to be added in the course name column in the future. I would like to make this formula to exclude those blank cells…