Convert date format to "YYYY.MM.DD" in formula that combines date and text
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:
Any help would be much appreciated, thanks!
Help Article Resources
Check out the Formula Handbook template!