-
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…
-
Smartsheet Summary Counting Assigned to with multiple people in the field.
I have the sheet below and I want to count for each person how may items are pending their approval. The formulas I have tried only find where it is only one person in the column. Where there are two people in the column it ignores the column. I have tried =COUNTIFS([Pending Approval From]:[Pending Approval From],…
-
Ignoring Blanks when Identifying Duplicates
Hello! I've been struggling with this and keep coming up with nothing. Would love some help please! We have a sheet with sessions for a conference, in which I've added helper columns to identify the duplicates (for speakers that have more than one session at a time). As of right now, everything is coming up as a duplicate…
-
How to use Countifs and AND and Ors
I am trying to make a chart that will count how many projects an employee is on given a certain criteria. Based off of my master project list sheet, I want to know how many projects my team members have each quarter (active and upcoming) I would like it to say count if employee name is employee@row AND Project Status is…
-
COUNTIF in an IF formula
I am trying to see when a segment is fully completed. Our segments can be broken out into subsegments, and they can have up to 5 subsegments, indicated by the segment number followed by a "—1", "—2", and so on. So far for this formula I've gotten it to count how many subsegments there are, but can't get the final push of…
-
Creating a bar chart showing task owner name and the count of tasks (25 possible task owners)
Hi, I am creating bar chart showing the names of task owners and the count of tasks assigned to them. I achieved this by listing the task owner names in my metrics sheet and getting the count by using the countif formula. But now I am told there is 25 task owners (instead of 5). So, I updated the metrics sheet with all the…
