-
How to record date without time
I would like to use automation on a sheet to record the Open and Closed date for a given RAID item. I don't want to record the time, however. Is there a way to exclude a time stamp from the automation? If it is not possible to exclude the time stamp, what formula would I need to use to extract the datae and time into…
-
How to create a time stamped column with the date
How do I create a time stamp column to auto populate the date and time of when a cell changed from blank to a value? The workflow to fill in a date does not provide the time and I cannot figure out a formula that would capture both date and time?
-
Forms - Time to complete
Every other form Microsoft, google, etc. has time to complete. Please add this function.
-
Latest Comment Copies Wrong Time
I have two columns that I have users enter data, formula combines it with the current modified date and time, then automations copy those rows to another sheet, so the history is preserved with the time. I then use the JOIN/COLLECT trick in new columns on the original sheet to show a log of that data change over time. One…
-
Can you filter a sheet to view entries between two times the days prior?
I am looking to filter a sheet to show only entries made between 6AM yesterday and 6AM the day before yesterday. I tried using a helper column with the below formula to input a value that I could then use in a sheet filter to show only those rows with a value of "1" but am getting an error in return. =IF(Created@row <…
-
Time Stamp for Approvals
We need the ability to record a time stamp for approvals. I found a workaround, but having it natively in Smartsheet like recording a date would be so much cleaner.
-
Automation based off auto-date-stamps not always working
Hi, I'm having intermittent trouble with a move-row-to-another-sheet automation triggering off of a Record a Date automation AND a user selecting a drop down. Process- A user creates a PO and enters data into the PO Number field. The Record a Date automation recognizes any input into this field and posts a date into the PO…
-
Is there a way to capture seconds in the last edited column?
I would like to get the last edited timestamp column as mm/dd/yy hh:mm:ss.ss as opposed to the standard mm/dd/yy hh:mm. For example I would like 08/13/24 13:53:47.89 instead of the normal way that smart sheets rounds numbers to the nearest minute.
-
Trouble with Time Tracking
We are working on a sheet to show the avg time spent on our tasks and we figured out how to time track as Smartsheet does not yet allow time tracking. Our solution was when someone selects "in progress" the row will be copied to another sheet. In that sheet we have a formula to grab the time from the created date and…
-
Has anyone figured out how to incorporate a timer?
My team is used to entering their time into Harvest which has a desktop timer. They start it when they begin a task and stop it when they are done. Although I've been told and read Smartsheet doesn't have a timer, I did find reference to one on Smartsheet's website.…
-
Time function Glitch
Hi, I noticed a strange glitch that occurs when using the Time() function. I'm basically trying to mimic a stop watch by calculating the duration of a start and stop entry utilizing the created date/time stamp. I have setup automation to move the rows that are entered as stop to another sheet. I extract the time portion…
-
Hour notification
Hi, When a user marks a row as in progress and it is still in progress 4 hours later. Is it possible to have the manager notified 4 hours after it was marked in progress and if it is still marked in progress.
-
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…
-
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…
-
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…
-
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…
-
Help to set a time column to CST time zone
We have a daily task at the beginning of the day in which the first thing to do is to review and track the number of tickets accumulated outside of working hours from our system. The timestamp column comes from the system with the format "datetime", in another separate Smartsheet we are trying to show the date on the top…
-
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:…