# Countifs using max(startdate) function

✭✭

• ✭✭✭✭✭✭

Do you have more context to your question?

• ✭✭

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)

• ✭✭

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)

• ✭✭✭✭✭✭

Are you able to provide some screenshots for context?

• ✭✭

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

• ✭✭

@paulnewcome did you understand ?

• ✭✭

anyone wants to lend a hand here ????

• ✭✭✭✭✭✭

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

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

• ✭✭
edited 08/29/24

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)

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

WeekBeginningDate

• ✭✭✭✭✭✭

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!