Workaround for broken UTC System Created Date Column
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
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!