nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

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

Find more posts tagged with

Human Resources

Construction

Formulas

Services

Support

Comments

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

smartsheet countifs formula.PNG

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Find MAX non-blank cell with matching criteria
Hi all! I'm working on a column formula that will check whether the Column2ref cell in the current row is blank. If it is blank, the formula finds the maximum value in the ID column where the Trainer Name matches the Trainer Name cell value in the current row and the ID cell value is less than the ID cell value in the…
Form Submitter
How do I see who submitted a form for a specific sheet?
Gantt view reporting activity in coming week
Hi, I have a Gantt covering 500+ rows of events past and planned. I use it to predict and track values around these events. Using helper columns to identify the current week, I get an email report on a Monday that tells me the upcoming events in the current week (7 days) and their values. Currently if an event spans…