I need a sheet summary formula that recognizes Previous quarter and current quarter.
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?
Ricky T
Gov Contractor for USSF
Best Answer
-
Try something like this:
="Q" + ROUNDUP(MONTH(TODAY()) / 3) + " " + YEAR(TODAY())
Answers
-
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().
-
@Paul Newcome you dont happen to have those quarter formulas or know where I can see them?
Ricky T
Gov Contractor for USSF
-
Try something like this:
="Q" + ROUNDUP(MONTH(TODAY()) / 3) + " " + YEAR(TODAY())
-
So this is what I got to work @Paul Newcome
="Q" + ROUNDUP(MONTH([Launch Opportunity Date]@row) / 3)
Ricky T
Gov Contractor for USSF
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!