Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
I am using a formula to concatenate several fields, one of which is a date field which contains forward slashes (e.g. 02/09/16).
Is it possible to modify the formula so that it removes the slashes from the end result and appears as 020916?
You can use the MONTH() DAY() YEAR() functions to pull out this information individually then concatenate them together.
Here's an example:
=MONTH([Date3]3) + "" + DAY([Date3]3) + "" + YEAR([Date3]3)
Change [Date3]3 to the cell or formula containing the date.
That formula would turn this:
02/11/16
To this:
2112016
You can then modify this formula if you want this displayed other ways.
Like this:
=IF(MONTH([Date3]3) < 10, "0" + MONTH([Date3]3) + "" + DAY([Date3]3) + "" + RIGHT(YEAR([Date3]3), 2), MONTH([Date3]3) + "" + DAY([Date3]3) + "" + RIGHT(YEAR([Date3]3), 2))
This would turn this:
Into this:
021116
