Data Mesh using different dates
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?
Best Answer
-
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
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives