Convert date format to "YYYY.MM.DD" in formula that combines date and text

anna_ashby ✭✭
edited 12/09/19 in Formulas and Functions

Is there a way to do something like the excel formula =TEXT(TODAY(),"YYYY.MM.DD") in SmartSheet to allow a specific date format to appear in the output of a formula, regardless of the user's regional settings? 

All of our date columns have been set to the YYYY.MM.DD format, but we have formula columns that combine dates from the date columns with text. Those formula columns cannot have the date format applied, so the dates they output just take on the format of the user's regional settings. Since we have users in different regions, we would like all dates from formulas to be displayed as YYYY.MM.DD if possible, but I can't seem to figure out how to do this.

Here's an example of the formula:

=IF([DateColumn]@row <= TODAY(), [DateColumn]@row + " - " + "Sample Text", "")

Any help would be much appreciated, thanks!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!