Countifs using max(startdate) function

AjS

Paul Newcome

Do you have more context to your question?

AjS

Hi Smart people,

I am creating a calculationsheet in my smartsheet,

1. I have a multiple teams (5 separate sheets) sheets with Project name, description, effort points, Status(dev, test, uat, done) weekstartdate and weekenddate
2. In my calculation sheet, I have columns project, dev, test, uat, done. here I am trying to count number of status for each status (like dev, test, uat, done) using max(weekstartdate)

AjS

i am using like this without even max function, not even sure if this is correct

=COUNTIFS({Team Squad - Team Project Status R Range 2}, Project@row, {Team Squad - Team Project Status R Range 1}, Committed$1)

Paul Newcome

Are you able to provide some screenshots for context?

AjS

above my calc sheet

Below, my individual team sheet (I have 5 like these) from this i am trying to pull only max(weekbeginningdate) values not all

AjS

@paulnewcome did you understand ?

AjS

anyone wants to lend a hand here ????

Paul Newcome

Your range/criteria set would look something along the lines of…

{Date Range}, @cell = MAX({Date Range})

AjS

@Paul Newcome

 could you get me full expression using this =COUNTIFS({Team Squad - Team Project Status R Range 2}, Project@row, {Team Squad - Team Project Status R Range 1}, Committed$1)

and your date function

{Date Range}, @cell = MAX({Date Range}) using my date column name

WeekBeginningDate

Paul Newcome

@AjS You would simply add it to the COUNTIFS the same way you have your other range/criteria sets.