Add Ons and Integrations
Add Ons and Integrations
Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.
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
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Trending Posts
- Hello Smartsheet Community! I have a question. Background: I have a Smartsheet which the team might use to easily enter project time, day by day (as a monthly timecard). I want it to be as streamlined…
- I'm wondering if others have had a similar experience with Data Table during the past week. When connecting to a Data Table the user is asked to choose "Add & Update Mode" or "Lookup Mode". For severa…
- Hello all - I'm looking to see if anyone has figured out a way to be alerted when sharing permissions change at a Workspace level? I know there's a template automation for sheet level sharing permissi…
