Conditional Formatting on Date is not taking into account local account timezone settings

PeterG

Conditional formatting using a date, is not taking into account the local account regional settings/timezone and appears to be using a default time zone.  As conditions like change the color of a cell if the date in that cell = Today, is still highlighting the cell on the next day.

My Time zone is set to Australia/NSW (GMT+11), but at 8:30am on the 31/01 (local time) the condition to change the color of a date cell if = today, and the value of that cell is 30/01/2019 (noting AUS regional setting so date format is DD/MM/YYYY), the cell is still highlighted, a day later.

Alejandra

Hi Peter, 

It's possible at you're looking at the cell through a report (https://help.smartsheet.com/articles/522214-creating-reports), which won't refresh conditional formatting on the source sheet. If so, I would suggest opening the source sheet and saving it.

Otherwise, it's possible there are multiple conditional formatting rules applied to the sheet. You could try disabling rules that appear similar to see if anything changes. If needed, more information on this can be found in our help article: https://help.smartsheet.com/articles/516359-conditional-formatting

If the above doesn't work, reach out to our Support team.