Weekly Tracking for a Dashboard
I have a grid where I am trying to lookup from a grid that people can log issues on. The first lookup is the date range, we want to count all issues within that date range. Then we only want to count by the "Field". On the log it is the column titled Field it is a dropdown of those fields listed on the Weekly trend grid as you can see our COUNTIFS formula is returning zero results. We tried to switch around with no luck. I can get it to populate with just the Filed, however when I try and add a DATE or WEEK, that is when I get "0". Thank you for any advice the community may have.