Formula to calculate the amount of "done" rows for different years.

Hugo Martinwall
edited 12/09/19 in Formulas and Functions

We do a lot of service jobs that we use smartsheet for. When its done they mark status as "Done". I know I can find the total amount of done rows by: =COUNTIF(Status:Status; "Done"). But how do I make the formula filter for jobs done in 2018 or 2019 etc?

Kind Regards,

Hugo Martinwall


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!