Workaround for broken UTC System Created Date Column

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(Created@row, 7, 2)), VALUE(LEFT(Created@row, 2)), VALUE(MID(Created@row, 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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!