Date Format sometimes incorrect


Firstly I am using English formatted dates DD/MM/YY (because the US format is wrong and terrible)

I have a sheet with dates in it. I have another sheet that points to these dates.

If my source dates are 33/12/2021 or similar they work correctly

If my source dates are for example 06/12/2021 then they appear incorrectly on the new sheet as 12/06/2021 even though the format is correct in the settings in everything

This is a major bug and needs immediate repair please, otherwise we cannot use this software.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!