-
Converting a Text Timestamp into a Numeric Timestamp Value
Problem: When timestamps are imported into smartsheet, the timestamp must be imported as a text field to retain its time aspect. Although the timestamp can be separated into a Date field and a Time field, this separation of Date and Time makes arranging the sheet into timestamp chronological order difficult. Solution:…
-
Needing Two Timestamps in One Smartsheet
Hello, Can someone please assist with having two timestamps? I need to have our "Timestamp" in the first column when the customer submits a quote request, and another timestamp in "Arista Timestamp" (with date and time) of when "Quote Request Sent To WWT?" changes to "Yes". Right now my workaround is to have it record a…
-
Data Shuttle Import Timestamp issue
I am attempting to import data from Excel with several Date & Timestamp fields. The format in the source file is: 04/16/2024 21:17 What I get in Smart Sheet upon Import: 45371.83695601851851851851851851852 I have tried leaving the destination column as text/number, I have tried setting it to Date - no dice. The default…
-
Need help with tracking time
I am barely new to Smartsheet but I can see the potential of helping me with my job duties, I work as a service dispatcher, We have been running out of Microsoft spreadsheets but I don't know a lot of coding and VBA so if I figured out how to obtain the average time in when the tech arrives on-site versus the time back to…
-
Merged: record time in automation
This discussion has been merged.
-
Publish a calendar showing times through 3rd party integration
Looking for a way to publish calendars to outlook and have them display at the correct times, not as all day events. Based on community post review, I am assuming the following: It is not currently possible to store a time in a date column (although the created/modified columns have that ability) Published calendars show…
