Sign in to join the conversation:
So I want to see how many Not Started, In-Progress or Completed each person has.
Here you go.
=countifs([Assignee Column TItle]:[Assignee Column Title], "Assignee Name", Status:Status,"Not started")
Just replace Assignee Column Title with the title of your assignee column and replace assignee name with the name of your assignee. It can't be the email address but rather the display name.
Just change the status "Not Started" To whichever Status you want to replicate it for the other status' you are checking.
Thats Great Mike, so do I have to have a seperat formula for each status? or how can I show Mike Wilday 3 completed, 2 Not Started 1 In-Progess?
You could do something like this...
="Assignee Name: " + COUNTIFS(Assignee:Assignee, "Assignee Name", Status:Status, "Not started") + " Not Started; " + COUNTIFS(Assignee:Assignee, "Assignee Name", Status:Status, "In Progress") + " In Progress; " + COUNTIFS(Assignee:Assignee, "Assignee Name", Status:Status, "Complete") + " Complete;"
You would have to replace Assignee name and adjust your columns if they are different than Assignee and Status.
See screenshot for example.
Thank you it worked fine!
Awesome. Glad I could help.
Hey Mike, for some reason it wont pick up the rest of the Status only Not Started. What am I doing wrong here?
="Trinity Castle: " + COUNTIFS([Sales Rep]:[Sales Rep], "Trinity Castle", Status:Status, "Not started") + " Not Started; " + COUNTIFS([Sales Rep]:[Sales Rep], "Trinity Castle", Status:Status, " In-Progress") + " In-Progress; " + COUNTIFS([Sales Rep]:[Sales Rep], "Trinity Castle", Status:Status, "Complete") + " Complete;"
Trinity Castle: 1 Not Started; 0 In-Progress; 0 Complete;
Found the Typos, my bad they all work thanks again
Okay cool! Glad it's working!
I need a column formula that can add sequential, unique IDs to data like this coming in from a form: Task Type Task ID Manual M001 Automated Manual M002 Manual M003 Manual M004 Automated Manual M005 Task IDs that aren’t the manual type need sequential numbering within their type (i.e. A001, A002, etc). Here’s the kicker:…
I'm trying to display a sum of the column Total Funds Available when Status = Apps Open, and Value Score = 5. Here is the formula I have: =SUMIFS([Total Funds Available]:[Total Funds Available], Status:Status, ="Apps Open", [Value Score]:[Value Score], ="5") There are rows that meet these conditions and should display a…
Hi everyone. We have an upcoming project is very short, but very critical, and requires that we track not only the start and end dates, but also the start and end times. Currently our team has added two columns, start time & end time, and they would like to add a duration column that can track the planned duration in…
