# max(startdate) function in Countifs.

✭✭
edited 08/29/24

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

• Overachievers Alumni

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")

• Overachievers Alumni

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")

• ✭✭

Thank you @David Tutwiler

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!