Current, Previous, Next Fiscal Qtr column formula
Can anyone help with a formula that could return "Previous", "Next", "Previous" fiscal qtr base on a date?
Answers
-
This formula will give you a result for each quarter of the year.
=IF(AND(Start@row >= DATE(2024, 1, 1), Start@row <= DATE(2024, 3, 31)), "Q1", IF(AND(Start@row >= DATE(2024, 4, 1), Start@row <= DATE(2024, 6, 31)), "Q2", IF(AND(Start@row >= DATE(2024, 7, 1), Start@row <= DATE(2024, 9, 30)), "Q3", IF(AND(Start@row >= DATE(2024, 10, 1), Start@row <= DATE(2024, 12, 31)), "Q4", " "))))
You can than filter based on the result. Does this get you what you need?
-
No, sorry
While i know that works, i don't want to have to filter reports every qtr or month (i have the month figured out). Just need a Qtr formula.
Would be great to create a "prev", "next", current" formula based on the date.
Or for Smartsheet to have this type of thing built in to filters. Including Rolling 3, 6, 12 etc...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!