Totals From SUMIFS Displaying Incorrectly Within Sheets and Dashboards

Paul Newcome

Ok. I typically only see this being an issue when dates are involved. I can't say that I've seen it throw off the hour for a specific chunk of time though. We may have to try a few things to see if we can get something working...

So I don't think it is actually showing 1pm. I think that the backend being 3 hours behind (Seattle time zone) is registering the LEN as less than 5 which only pulls in that first digit.

Lets try this in place of the [Created Hour]...

=LEFT([Created Time]@row, FIND(":", [Created Time]@row) - 1)

If this doesn't fix the issue then it will at least help us confirm that that is the actual issue and not something else.

zbr

This formula worked! I have monitored the way the data pulls in and there is no longer any inconsistency. Data displays correctly now! @Paul Newcome Thank you!!!

Paul Newcome

Happy to help. 👍️