Count If Current Week
Options
Answers
-
I've double checked and there are defintely other rows that fall within the same week.
-
Hi @Lisa Suong
What happens if you replace the WEEKNUMBER(TODAY()) with the actual number for today?
For example:
=COUNTIFS([Week Number]:[Week Number], 10)
Does that still give you 0?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!