Formula to count issues raised this quarter and in previous quarter
I am putting together a metric sheet that will count issues raised based on various dates. I already have it set up to count this month vs last month, but I need help doing the same for quarter.
In my main data set I have added a helper column to return the quarter based on the date an issue was flagged. How can I use this to do a count for this quarter and last quarter? It would need to be dynamic so that it automatically adjusts as we move into a new quarter (I don't want to have to edit the formula at the beginning of each new quarter if at all possible).
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!