Countif function within a specific month, what is my error


Hello all,

I'm beginning with the functions and I'm struggling here with this instance:

My objective is to add a chart to a dashboard, my information table is as follow, Basically I want to count the number of request per month and include them in a bar chart.

So, I made a calcsheet to extract the information to generate the chart.

I want to count the number of request made in november

So here is the formula I'm trying and on the following row, the error I get:

=COUNTIF({Date de la demande};(Month(@CELL) = 11)

Please let me know what I'm missing?

Thanking you in advance,


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!