Formula To Return Value based on Month
Hello,
I am attempting to recreate a formula I have in Google Sheets to return a quarter number based on the Month. Ex: If a cell has "March", it would be Quarter 1. The original formula involved =IF(OR(ISNUMBER(SEARCH("December", F3)), in Google Sheets and I was able to have it work, albeit with several lines of text after that.
Is this possible to replicate in Smartsheet?
Thank you.
Best Answer
-
Hi @GDHernandez,
Would something like this work for you? Naturally swap out [Column4]14 for the cell providing the date.
=IF(MONTH([Column4]14) <= 3, "Qtr 1", IF(MONTH([Column4]14) <= 6, "Qtr 2", IF(MONTH([Column4]14) <= 9, "Qtr 3", "Qtr 4")))
Hope this helps.
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile - Open to work
Answers
-
Hi @GDHernandez,
Would something like this work for you? Naturally swap out [Column4]14 for the cell providing the date.
=IF(MONTH([Column4]14) <= 3, "Qtr 1", IF(MONTH([Column4]14) <= 6, "Qtr 2", IF(MONTH([Column4]14) <= 9, "Qtr 3", "Qtr 4")))
Hope this helps.
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile - Open to work
-
It did, thank you Jason! It took some tweaking on my end, but with your formula I was able to get this working. Thank you! @Jason Albrecht
-
Great news.
Thank you for the feedback.
Have a great day.
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile - Open to work
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!