Apply Standardized Date Formats in Your Sheet

Depending on locale, you might read a numerically formatted date in a different order from colleagues—for example: MM/DD/YY versus DD/MM/YY. You can apply a date format which will be interpreted in the same manner for everyone on your team, regardless of their Regional Preferences they’ve set in their Smartsheet account.

The formatting options discussed here can only be applied to Date type columns at this time.

Who can use this capability?

Editors, Admins,and the sheet老板can apply a date format in a sheet. Anyone shared to the sheet can view the date format that has been applied.
All Smartsheet accounts.

Apply a Format to the Whole Column

In your sheet:

1. Click the datecolumn headerat the top to select the entire column.
2. Click theDate Format buttonin the toolbar.
   
   
   
3. Select the desired date format.

就是这样!应用格式存在ures that all current and future dates typed in the Date column will have your desired formatting.

Apply to Specific Cells

You can also select individual or groups of cells to apply date formatting to in a more specific manner. Keep in mind that when you apply formatting in this way, new information added to other cells in your Date column won’t have the same formatting.

How Date Formats Appear to Collaborators

When you apply a different date format to a column, it will appear standardized to all collaborators on the sheet. Depending on your Regional Settings, months and days of long form date formats will also appear localized in the following languages:

• English
• Spanish
• German
• Italian
• Portuguese
• Russian
• Japanese