Data Mesh using different dates

Sophie Knudson · 03/01/21

Hi there,

I have two sheets that track some of the same information. I use DataMesh to reduce the need for duplicating work and reducing risk of error.

On my inventory form, I have a column that is system generated so when someone fills out a row, it automatically populates with the date and time. I received something on December 31, 2020 at 4:37pm.

On my tracking sheet, I use DataMesh to capture when I received the product by pulling from our inventory form. However, the date listed in my tracking sheet is "1/1/21".

Does anyone know why this changed or how to resolve this discrepancy?

Sean Morgan · 03/05/21

Hello @Sophie Knudson ,

I believe that this is related to our Premium Apps working on UTC Time.

Assuming your are in the PST Timezone, When I converted 4:37pm PST to UTC, it showed 00:37 the next day.

With this, you may wish to use a Formula in the following post for performing a conversion of time: https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time/p1

You could then convert this into a Column Formula for extracting the correct submissions Time/Date. For more on Column Formulas, please see the following article: https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

Let me know if you have any questions!

Regards

Sean

Sean Morgan · 03/05/21