-
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…
-
Need a formula to count the number of individuals who have (any number of) contracts in the sheet
Hi SS Experts! I have a sheet with rows and rows of contracts and need to count how many individuals have contracts in "active" status. One person might have four active contracts, but I only want to count that person once. Could you please help?
-
Help with Countif Across Multiple Columns if the Row Starts with "Project Mangement"
Hello, I am struggling with a formula and hope the community can assist me. I've created a helper sheet to automatically pull in the month, day, and day of the week. The goal is to count the total number of green or blue symbols that occur in August if that row starts with "Project Management". For example, looking at the…
-
Countifs with two conditions
I was having a hard time with this formula - Not sure why I am getting it wrong. What I am trying to do is - If Column A is Student and if Column C has Enrolled or Enrolled - Incompleted, Count. The formula I have is follows: =COUNTIFS({Courses Projects}, "Student", {Courses Status},OR(@cell =…
-
COUNTIF Function with AND Function
Trying to count instances where item has PV-E Validation and the Status is Complete. My current formula is below and is not working. =COUNTIF({PV Type}, "PV-E Redemption") AND({PV Express Status}, "Cancelled"))
-
I have a column formula applied to a Status Column, however it is not applying to one of the rows.
The column formula is: =IF(Progress@row = "Complete", "Blue", IF(Progress@row = "Upcoming", "Green", IF(Progress@row = "Ongoing", "Green", IF(Progress@row = "Commenced", "Green", IF(Progress@row = "On Hold", "Yellow", IF(Progress@row = "Discontinued", "Red", IF(Progress@row = ".", "", IF(COUNTIF(CHILDREN(), "Blue") =…
