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

Hugo Martinwall

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

Hugo Martinwall

I ALMOAST solved the above problem! Here I have different statuses on each row with identical formulas except "Done", "In Progress", "Not Started" etc.

But the formula says #INVALID DATA TYPE on 3 out of 8 rows... How do I fix this?

The formula I have used is: =COUNTIFS({Order Bok Range 1}; "Done"; {Order Bok Range 2}; YEAR(@cell) = 2019)

Kind Regards, Hugo Martinwall

Andrée Starå

Hi Hugo,

Check the ranges for data that isn't in the correct format.

More info: https://help.smartsheet.com/articles/2476176-formula-error-messages?_ga=2.163823034.487922610.1554120052-1302373248.1552411124#invaliddatatype

Did you find it?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Hugo Martinwall

Hi Andree,

Thank you for the quick reply!

I emailed you the problem in more detail. Still Can't figure out what the problem is!

 

Kind Regards,

Hugo Martinwall

Andrée Starå

Happy to help!

I'll take a look and get back to you!