-
Merge Date and Time, then calculate hrs remaining
Looking for your help, so we have a project manager that has the below information on a sheet. And what he is looking for, is to have a column that calculates how many hrs left each row has before it reaches its planned end date/time. That way they can either add filters or conditional formatting for the rows that are due…
-
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…
-
Merged: Feature Request: Duration Calculation from Date & Time Columns
This discussion has been merged.
-
Merged: Timestamp Automation
This discussion has been merged.
-
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…
-
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…
-
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.