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 am trying to pull a phone number and email from our master roster that is on another sheet in Smartsheet. I cannot figure out the formula. This is the formula I have tried. =INDEX([EMPLOYEE NAME]@row , MATCH({IMS Master Roster Range 2}), 0)
Hi All, I keep getting this annoying error when I try to trigger a PDF generation. I initially set up to trigger the PDF generation to kick off once the last field the needs data is "not blank". That is when the error started. I modified the sheet and added a yes/no drop down to trigger the PDF generation when the value in…
Desired result is to pull the Initiative Name where the Days to Due Date is the least (so, due the soonest); then to make an index for the Top 10 Initiatives Due Soonest Currently using this formula: =INDEX(COLLECT({Project Master - Initiative}, {Project Master - Days to Due}, MIN({Project Master - Days to Due})), 1) This…
