Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formatting Date in Smartsheet with Month Name Displayed
When using the column type of "DATE" the only way dates are always displayed as numeric values. However, some of my colleagues are requesting that the dates be displayed as Feb 12, 2016 or 12 Feb 2016, etc.
Is this possible in Smartsheet? The only preferences I have located are the user preferences where you localize your date syntax (mm/dd/yyyy versus dd/mm/yyyy and and numeric/currency related syntax); however, this doesn't seem to offer anything that will fulfill the request of my colleagues that are opposed to reading numbers.
I have two date columns and then in a 3rd column I display these together for a quick reference when scanning through for a particular entry:
=[Event Start Date]1 + "- " + [Event End Date]1
Perhaps if it's not possible to modify the display of the Event Start Date & Event End Date columns can I do so in my combined column which uses the formula above?
I know how to do this in Excel or PHP ex: (date('F m, y');, however, I'm a bit stumped right now. I'm also rather baffled as to why this is considered to be a necessary feature from my colleagues.
Anyway, I'll end my rant here. Thanks for any help or guidance you can provide!
Comments
-
Sorry, I'm doing too much and didn't check for duplicate requests and looks like this question was asked yesterday as well. However, neither have responses yet.
https://community.smartsheet.com/discussion/how-convert-dates-long-form-date-format
-
This is possible. Check out my answer here: https://community.smartsheet.com/discussion/how-convert-dates-long-form-date-format
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives