COUNTIFS error when finite rows not set


I have a formula that calculates the week number, and counts all items with the priority of 'Standard' within that week.

The issue is that my 'Creation Date' column currently has 97 rows, but this will increase. The formula below works, but not if I remove the row numbers. I haven't seen this behavior before, did I set something up incorrectly? (First and last row are constant, the week number is between 1-52).

=IFERROR(COUNTIFS([Creation Date]$1:[Creation Date]$97, WEEKNUMBER(@cell) = [Week#]@row, Priority$1:Priority$97, "Standard"), "lorem")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!