Assistance with COUNTIFS and dates
Hi,
I am trying to count the status of a tasks that have range of Start Dates for that week and keep receiving "Unparse" error message.
Answers
-
Can you provide the formula you are currently trying?
It should look something like this:
=COUNTIFS({Date Range}, AND(IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER([Target Start Date]@row), IFERROR(YEAR(@cell), 0) = YEAR([Target Start Date]@row)))
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!