# Count tasks submitted by month

I need help with a formula to count tasks submitted by month please. I am not adept at logical functions and formulas. I have tried some of the suggested formulas from the lessons but none of them worked. The column property is set to DATE. Do I use countif? a sample formula will be much appreciated.

• ✭✭✭✭✭✭

I hope you're well and safe!

Try something like this.

```=COUNTIF({Date Submitted}, IFERROR(MONTH(@cell), 0) = 1)
```

Did that work/help?

I hope that helps!

Have a fantastic week & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭

Use a helper column "MonthNumber" to determine the month number for each row. The MONTH function returns the month number from a date field, 1=January, 2=February, and so on:

```=MONTH([Submitted Date]@row)
```

In Summary fields (or on a metrics sheet or whatever,) use COUNTIF to count the number of rows for each month:

```=COUNTIF([MonthNumber]:[MonthNumber], "1")
```

Repeat for in summary fields for the remaining 11 months.

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• thank you! What if I am referencing the source of the data from another sheet?

• ✭✭✭✭✭✭

In that case, when you start your COUNTIF formula, the "Reference Another Sheet" link pops up. Use that to select the MonthNumber column from your source sheet.

You will have an option to name the range. I usually change it from 'Source Sheet Range 1" to something more meaningful, such as "Source Sheet MonthNumber". Then your COUNTIF formula will look something like this:

```=COUNTIF({Source Sheet MonthNumber}, "1")
```

The squiggly brackets indicate that it's a range on another sheet.

The nice thing is, once that range reference has been created for the sheet, you won't have go through the "Reference Another Sheet" operation again for the other months. Just copy/paste the formula into your remaining summary fields and change the month number.

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• somehow it didn't give me an error message but the output are all zeros. What did I do wrong?

• ✭✭✭✭✭✭
edited 01/05/22

The output on your metrics sheet for the COUNTIF, or the conversion on the source sheet getting the month number from the Submitted Date field?

Share your formulas from each?

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭✭✭✭

Let's see the formulas/grid from your source sheet.

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• Not a formula but just a date field.

• ✭✭✭✭✭✭

I hope you're well and safe!

Try something like this.

```=COUNTIF({Date Submitted}, IFERROR(MONTH(@cell), 0) = 1)
```

Did that work/help?

I hope that helps!

Have a fantastic week & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭

OK, you're still going to need to add a helper column to your source sheet to extract the month number from the Date Submitted column.

Add a new column called "MonthNumber" with type Text/Number. You can lock and hide this column later. Create a column formula in MonthNumber:

```=MONTH([Date Submitted]@row)
```

Each row should then have a numeric value from 1 to 12 in the MonthNumber column. Save the sheet.

On your metrics sheet, reload the page. Edit your reference: In your COUNTIF formula, you can click inside the squiggly lines of {Date Submitted} and should see an option to Edit the reference. Select the MonthNumber column from your source sheet.

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• That worked!!!!!!😀 THANK YOU SOOOO MUCH!

I really appreciate the time and effort!

Have a great new year!

Wina

• ✭✭✭✭✭✭

Excellent!

You're more than welcome, and likewise!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Thank you @Jeff Reisman !! Your help was much appreciated!!!😀👌

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!