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

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    Hi @Emelia Hoover

    Hope you are fine, please try the following formula:

    =MID(Created@row, 11, 10)

    PMP Certified


    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!