Count of activities during current week

Hi there,

I'm trying to get a count of certain activities taking place during the current week to get an overall view of how many activities my team is completing in a week. The formula I am attempting to use is:

=COUNTIFS(Complete:Complete, "1", Helper:Helper, WEEKNUMBER(TODAY()))

Complete = Checkbox Column that helps me track when an activity has been confirmed

Helper = Additional column added to record an auto creation date since the date I want to use sometimes includes a time (HH:MM)

The formula above gives me a "0" and I have read through all the posts to figure out what I'm doing wrong. Any help is appreciated.

Best Answer


  • That worked perfectly...thank you so much!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!