max(startdate) function in Countifs.

AjS

Hi all, I am looking if someone cane help me in writing an expression,

I am creating a calculation sheet in my smart sheet,

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)

my target sheet

David Tutwiler

I think you should look at the COUNTIF function. It is what you should use to do counts with a single parameter. Something like:

=COUNTIF(Status:Status, "Done")

David Tutwiler

I think you should look at the COUNTIF function. It is what you should use to do counts with a single parameter. Something like:

=COUNTIF(Status:Status, "Done")

AjS

Thank you @David Tutwiler