Workaround for broken UTC System Created Date Column

05/29/20
Accepted

Hi, my problem is the same as in https://community.smartsheet.com/discussion/19461/wrong-date-showing-seems-to-be-4-hours-off-the-difference-between-gmt-and-my-time-zone


In short, I am on GMT-7 time, while Smartsheet operates under UTC. Because of this, whenever a System Date is generated for entries after 5PM, my sheet thinks its the next day. I tried to use the workaround presented in the referenced forum post, namely the

=DATE(VALUE(MID([email protected], 7, 2)), VALUE(LEFT([email protected], 2)), VALUE(MID([email protected], 4, 2)))


However, for the year I am getting 1920 instead of 2020. I am unable to add 100 years to that date for a reason I do not understand (nor can I add 1 year, etc.). Please could someone tell me how to get this working? Thank you!

Best Answer

Answers

Sign In or Register to comment.