Why am I observing this odd behavior with a "Created (Date)" column?

I think I've found a bug.

I have a column that is of type "Created (Date)" called "Date" and another column called "DATE TEXT" which is a text column.

DATE TEXT = Date + ""

DATE TEXT is calculated by appending a null string to Date. I have noticed erratic behavior in another sheet that references this column, and I believe I see the issue. For some strange reason, the DATE TEXT column was actually displaying a value of 2 hours earlier than the date displayed in Date. How is this possible?

I noticed this when I visited the sheet and saw the 2 hour difference, however it immediately prompted me to save the sheet, and once I did, the DATE TEXT immediately updated to match the value in Date.

This behavior is similar to how a formula written using TODAY() will not update until the sheet is interacted with. Can anyone explain this strange behavior? I would definitely consider this a bug.

DATE_DISCREPANCY.png formula.png


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!