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.