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")