I need a sheet summary formula that recognizes Previous quarter and current quarter.

RickyT

I have seen how to make a column formula that shows you what quarter something is, and i know I could make a sheet summary formula that calls what quarter it is from a column after making that column formula. But it feels like there is some sort of TODAY or YEAR function that I could use no?

Paul Newcome

Try something like this:

="Q" + ROUNDUP(MONTH(TODAY()) / 3) + " " + YEAR(TODAY())

Paul Newcome

It would be the same as other formulas that tell you the quarter based on a date, but you would replace the date references with TODAY().

RickyT

@Paul Newcome you dont happen to have those quarter formulas or know where I can see them?

Paul Newcome

Try something like this:

="Q" + ROUNDUP(MONTH(TODAY()) / 3) + " " + YEAR(TODAY())

RickyT

So this is what I got to work @Paul Newcome

="Q" + ROUNDUP(MONTH([Launch Opportunity Date]@row) / 3)

Paul Newcome

Happy to help. 👍️