Smartsheet Wrong Date Show Using System Created Time Date in a Calculation 

My eBook: Smartsheet User Guide for Accelerated Learning 👉 amzn.to/3i7jVPH (paid link)
Get my 7 Smartsheet Tips👉 www.smartsheet...
I apologize, the audio in this video is pretty embarrassing. See what I use to record now: smartsheetguru... (paid link)
You may find when performing date calculations in Smartsheet on Smartsheet System generated columns such as Created (Date) and Modified (Date) that the result is not what you expect. This is due to Smartsheet storing system generated columns as server time (UTC or GMT timezone) but displaying it as your local timezone within your Smartsheet view.
In my video is a nice little workaround. I like to call these sorts of workarounds "Smartsheet Gymnastics"
This issue is described in more detail on the Smartsheet community here:
community.smar...
#smartsheet #smartsheetcoaching #smartsheettutorial #howtousesmartsheet #coaching