count tasks per week number

Hi community,

I'm trying to count the tasks in my gannt per each week in a separate grid. Then i'll make a graph representing work overloads throughout the year.

Here is my formula that calculate 0 every time (at least not an error) :

=COUNTIF({6530 - Sulfuric project Schedule Range 5}, WEEKNUMBER({6530 - Sulfuric project Schedule Range 5}) = [Primary Column]29)

the range is the start column date of the task on my gannt chart

the primary column on local grid contains numbers of the weeks in the year (1-53)

screenshot attached.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!