Counting Tasks Due this week

Options

Hello - Im attempting to count the number of tasks due this week using the following formula:

=COUNTIFS([End Date]1:[End Date]50, =WEEKNUMBER(TODAY()))

I only get "0", back even when the [End Date] week number is equal to today. Any help with this would be greatly appreciated.

Screen Shot 2022-04-13 at 8.52.03 PM.png


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!