date format in reports

Julien Lopez ✭✭

01/13/25 in Formulas and Functions

Hi

i have different reports based on differents sheet and some have date format DD/MM/YY and other DD/MMM/YYYY. i'm looking on the way to have all of them on the same format DD/MMM/YYYY.

thank you all and happy new year :)

0 · Share on FacebookShare on Twitter

Answers

• 

  Melissa Yamada ✭✭✭✭✭

  01/13/25

  Hello @Julien Lopez

  You'll need to set the date format on each of the source sheets since reports are just representations of the sheet data.

  Melissa Yamada
  melissa@insightfulsheets.com
  Data made simple, spreadsheets reimagined

  1 · Share on FacebookShare on Twitter
• 

  Julien Lopez ✭✭

  01/13/25

  @Melissa Yamada thank you, i'll try it

  0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list