-
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") =…
-
Counting number of events (lines) within a time range
Hi, I looked at the past discussion but didn't find the answer. My sheet has a row for each events happening with the precise dates (ex: 8-Aug-2024). I would like to count any event that happened within a time frame (march 1rst to march 31rst of the next year). I tried various formulas but no luck at all…
-
Counting Text Color
Hello, I am working on creating metrics in our Smartsheet milestones. Currently, if a milestone was completed on-time, the date completed is turned green. If the milestone was not completed on-time, the date completed is turned red. What I would like to do is create a formula for metrics that reads the text color for how…
-
Countifs formula Error
Hi, I have one main sheet and i'm going to pull data from that to another sheet, in this case i need to count my new Client Details within the particular date range, the problem is Project name details is repeating in the colounm (Single project has multiple products so i've kept seperate entry for all the products due to…
-
How do I COUNT items according to the criteria of Date and Category?
I am try to create a metric to understand how many items were shipped in a month, according to the product type. Can some one help with the formula from the example below?
