Date format gets reversed !

Options

Hi Community,

I need the date set to be dd/mm/yyyy, My system settings are also the same. The problem I encounter is that whenever I do a cell reference and pull the information from a reference sheet, the format gets changed to MM/DD/YYYY. Due to which unable to filter the summary of data for each month and had to do a manual correction to generate the report.

I checked the Smartsheet date format too - it is set as below.



Date format reversed dd/mm/yyyy to MM/DD/YYYY - Is there a Formula to verify the date? Please advise.

Thanks in advance,

Don.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!