Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

Default date and number formats with Regional Preferences

Smartsheet displays dates and number formats according to the Regional Preferences you've specified for your account.

Who can use this?

Plans:

  • Smartsheet
  • Pro
  • Business
  • Enterprise

Using Regional Preferences, you can specify the dates and number formats for your account.

For example, if Regional Preferences is set to English (United States), dates are displayed in the format month-day-year. If you've set Regional Preferences to English (United Kingdom), dates are displayed in the format day-month-year.

To change the default date and number formats:

  1. Select Account > Personal Settings, to display the Personal Settings window.
  2. Select Settings in the left pane.
  3. Under Regional Preferences, select the desired value from the dropdown list.
  4. Select Save to apply the changes.

All dates and number formats in your sheets are updated to match the new setting.