Issues with TODAY() and daily reporting


Hi there. In part of my duties, I run a report that shows activities entered on a form from yesterday.

We do achieve "yesterday" by using the following formula:

=IF(DATEONLY(Created@row) = DATEONLY(TODAY()) - 1, "Yesterday", "Not Yesterday")

In using this formula we have noticed some alarming discrepancies. Reports with "Created" timestamps after 4:00 pm are treated differently in terms of their date. Namely, they roll over to the next day. Here is a screenshot to give you a better idea as to what I'm working with:

I have confirmed my timezone settings to be correct (I am PST).

As a reference, the "time stamp" column is a formula to remove the date segment from created. The date returns on every record reported after 4:00 pm. This is also confusing. The formula for the "Time-Stamp" column is:

=SUBSTITUTE(Created@row, DATEONLY(Created@row), "")

Are there known issues around time stamps issues? Am I secretly 8 hours ahead? Does the smartsheet staff have any insight here or has anyone else experienced issues like this?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!