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.
