A formula pulling Time from a System-Generated column does not stay consistent. Please help!

I am using a formula to pull the time from a system-generated column using Created (Date). The formula is =RIGHT(Created@row, 8). A majority of the time is accurately pulls that correct information but other times it is off by two hours.

For example, the screenshot is showing it accurately. But it will randomly switch to 10:56 AM randomly and later switch back to 12:56 PM.

This is affecting priority reports and automated workflows that is based on the Start Time column.

Am I using the wrong formula? Does anyone have a better solution to pull the correct information consistently?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!