Workaround for broken UTC System Created Date Column


Hi, my problem is the same as in

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


Sign In or Register to comment.