How to extract Month only from Date column format eg. Apr 6, 2021
Hi All,
I am a novice in Smartsheet Functions and need some help.
How can I extract the month only (i.e. Apr) from Date column format e.g. Apr 6, 2021 in the same Smartsheet?
Thanks.
Janice
Best Answer
-
Hi @Janice Phua
I hope you're well and safe!
You can use =MONTH(Date@row), and if you want to show the month name, you can use the below formula for that. Otherwise, it will show as a number.
=IF(MONTH(Date@row) = 1; "January"; IF(MONTH(Date@row) = 2; "February"; IF(MONTH(Date@row) = 3; "March"; IF(MONTH(Date@row) = 4; "April"; IF(MONTH(Date@row) = 5; "May"; IF(MONTH(Date@row) = 6; "June"; IF(MONTH(Date@row) = 7; "July"; IF(MONTH(Date@row) = 8; "August"; IF(MONTH(Date@row) = 9; "September"; IF(MONTH(Date@row) = 10; "October"; IF(MONTH(Date@row) = 11; "November"; IF(MONTH(Date@row) = 12; "December"))))))))))))
Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.
Did that work/help?
I hope that helps!
Be safe and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi @Janice Phua
I hope you're well and safe!
You can use =MONTH(Date@row), and if you want to show the month name, you can use the below formula for that. Otherwise, it will show as a number.
=IF(MONTH(Date@row) = 1; "January"; IF(MONTH(Date@row) = 2; "February"; IF(MONTH(Date@row) = 3; "March"; IF(MONTH(Date@row) = 4; "April"; IF(MONTH(Date@row) = 5; "May"; IF(MONTH(Date@row) = 6; "June"; IF(MONTH(Date@row) = 7; "July"; IF(MONTH(Date@row) = 8; "August"; IF(MONTH(Date@row) = 9; "September"; IF(MONTH(Date@row) = 10; "October"; IF(MONTH(Date@row) = 11; "November"; IF(MONTH(Date@row) = 12; "December"))))))))))))
Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.
Did that work/help?
I hope that helps!
Be safe and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks @Bassam.M Khalil.
Hi @Andrée Starå,
Thank you for the formula, could you provide me steps what I am to do with it? Copy and paste does not work for me 😅. Do I need to create a new column or etc.? Thanks in advance for the guidance!
=IF(MONTH(Date@row) = 1; "January"; IF(MONTH(Date@row) = 2; "February"; IF(MONTH(Date@row) = 3; "March"; IF(MONTH(Date@row) = 4; "April"; IF(MONTH(Date@row) = 5; "May"; IF(MONTH(Date@row) = 6; "June"; IF(MONTH(Date@row) = 7; "July"; IF(MONTH(Date@row) = 8; "August"; IF(MONTH(Date@row) = 9; "September"; IF(MONTH(Date@row) = 10; "October"; IF(MONTH(Date@row) = 11; "November"; IF(MONTH(Date@row) = 12; "December"))))))))))))
-
Hi @Andrée Starå - after pondering on the formula - I manage to get it resolved by changing semi-colon to a comma. It works, thanks!
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Can you tell me what we are doing wrong here? We are getting an unparseable message.
-
Hi @CricketCO
There are two Month functions that are missing their opening parentheses (
For example, you have
MONTH[cell reference...
when they should be
MONTH([cell reference
I've underlined the two areas in your formula below:
As another note, I would suggest replacing all of the row references (the 1 after the [date]) with @row instead. This will allow you to turn it into a Column Formula:
MONTH([Email Send Date]@row)
See: Create Efficient Formulas with @cell and @row & Use column formulas to apply calculations to all rows in a sheet
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Hi There!
I have tried this formula with both brackets and parenthesis.
Ex: IF(MONTH((Date Submitted)@row)=1 and IF(MONTH([Date Submitted]@row) = 1
With both of these I am getting unparseable. Is there something I am missing?
-
Hi @Kpennington
Your second version of the syntax is the correct one:
IF(MONTH([Date Submitted]@row) = 1
Column names should be wrapped in square brackets, like so:
[Column Name]@row
I also notice that you have a ; (semi-colon) instead of a , (comma) after the 6 in your formula. You'll need to change that out as well!
Let me know if that fixed it for you.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
That was it! It was the semi-colon. Thank you.
-
Ok tried this formula. Change the ; to , and referenced my date field but I am getting an #INVALID Data Type. Help!
=IF(MONTH([Go Live Projection]@row) = 1, "January", IF(MONTH([Go Live Projection]@row) = 2, "February", IF(MONTH([Go Live Projection]@row) = 3, "March", IF(MONTH([Go Live Projection]@row) = 4, "April", IF(MONTH([Go Live Projection]@row) = 5, "May", IF(MONTH([Go Live Projection]@row) = 6, "June", IF(MONTH([Go Live Projection]@row) = 7, "July", IF(MONTH([Go Live Projection]@row) = 8, "August", IF(MONTH([Go Live Projection]@row) = 9, "September", IF(MONTH([Go Live Projection]@row) = 10, "October", IF(MONTH([Go Live Projection]@row) = 11, "November", IF(MONTH([Go Live Projection]@row) = 12, "December"))))))))))))
-
@ErinHell Did you double check that the [Go Live Projection] column is set as a date type column? If so, how exactly is it being populated?
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 that was the problem it was a text field. Thank you!!!!!
-
@Paul Newcome do you know if there is an iferror statement I can add to blank out fields where it doesn't apply?
-
@ErinHell Yes there is.
=IFERROR(orignial_formula, "")
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
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!