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())
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
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().
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@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())
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!