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

Emelia Hoover

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?

Bassam Khalil

Hi @Emelia Hoover

Hope you are fine, please try the following formula:

=MID(Created@row, 11, 10)

Bassam Khalil

Hi @Emelia Hoover

Hope you are fine, please try the following formula:

=MID(Created@row, 11, 10)

Andrée Starå

Hi @Emelia Hoover

I hope you're well and safe!

Please have a look at my post below with a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help? 

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!