Date error report

João Rego

Hi,

I have a formula that adds x days to a date. The date is displayed correctly, but when I use it in a report, the displayed date isn't the same.

For testing purposes, I added a column with the formula =[Próxima manutenção]@row+"", and the date that appears is different, but the same as the one that appears in the report.

Why is this happening?

João Rego

Another detail is that this doesn't happen every time; sometimes the date shown in the report or in that formula is the correct one...

Julie Fortney

@João Rego I've never seen this issue before, but I see another Community discussion from a year ago with a similar issue: https://community.smartsheet.com/discussion/99558/why-is-date-on-the-sheet-different-on-the-report

It doesn't appear the question was fully resolved, so I recommend submitting a support request so Smartsheet can look at all of your sheet and report settings.