Quarter Formula
I am trying to create a formula that extrapolates the quarter (Q1, Q2, etc) based upon the end date column. Has anyone done this before?
Thanks in advance for any help provided.
Best Answer
-
I use this although I'm not sure if this works beyond the last year. I wrote it a while back.
= "Q" + ((ROUNDDOWN(((YEARDAY([End Date]@row) - 5) / 365) * 4)) + 1) + "-" + RIGHT([End Date]@row, 2)
Answers
-
I use this although I'm not sure if this works beyond the last year. I wrote it a while back.
= "Q" + ((ROUNDDOWN(((YEARDAY([End Date]@row) - 5) / 365) * 4)) + 1) + "-" + RIGHT([End Date]@row, 2)
-
Thanks. I found an Excel formula that works.
="Q"+ROUNDUP(MONTH([Expected End Date]@row) / 3, 0) This formula works no matter the end year.
-
Thanks a lot, Its also help me a lot.
-
-
Many thanks! Your assistance has been incredibly beneficial.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 429 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!