Is it possible to count the number of entries in a column for the current work week, and quarter?
Is it possible to count the number of badge IDs in a column for the current work week, and a quarter? I need to track the progress of a weekly target that resets every Friday.
Currently, I can not get the CWs (blue) to align this is my starting point for all of our contract workers.
Here is one of my sheets created that we use for the dashboard (above picture)
Test Dashboard Data - Trending screenshot
Formula used in the above sheet Test Dashboard Data - Trending
Then we have a quarterly which I have created three columns and all three columns do not have the correct count.
All CWs Formula
Tried pulling a link in from my Test Dashboard Data - Trending