Month not displaying correctly
I have a sheet that contains a Posted column that is auto-populated with the created date. I have another column next to that that pulls the number of the month out of the date. Example would be the Posted column says created 03/11/2018 11:39 AM and the month column returns a 3.
The formula I am using works for every instance except one. The cell in question has a created date of 4/30/18 10:46 PM. The month column is returning a 5 for this date. I can't figure out why this is happening and it is the only instance that is incorrect. Any ideas?
Comments
-
I should have added that this is the formula I am using
=IF(ISBLANK([Posted Date]5), 0, MONTH([Posted Date]5))
-
This is, unfortunately, a known issue related to the way Smartsheet stores the underlying date.
This post, while long, covers it:
https://community.smartsheet.com/discussion/utc-date-fix-response-required
Craig
-
Craig,
Thank you for taking the time to respond. Seems like a major issue that needs to be addressed.
-
I agree.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!