-
Calculate duration between two times
Im looking for a formula to calculate difference between two times eg 08:00 - 10:00 should give a duration of 2 but running into errors. I have column types as text number. 08:00 is named Start Time and column for 10:00 is finish time
-
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…
-
Time Zones
Smartsheet "Reports" created dates are showing in UTC time, can this be changed to EST?
-
Formula for updating window of time to different time zones...
I am creating a form to schedule meetings however, I need the times I have listed in Pacific Daylight Time (PDT) to be converted into Mountain Daylight Time (MDT) (PDT+1 hour), Central Daylight Time (CDT) (PDT +2 hours), Eastern Daylight Time (EDT) (PDT +3 hours), and Greenwich Mean Time (GMT) (PDT +7 hours). I am manually…
-
Feature Request - Authoritative TODAY() functions
Context All Automations run on sheet owner time (in my case, Pacific time). Sheet columns generally use universal / UTC time in the backend (i.e. Created, Modified columns – so the time stamps are authoritative). However, the Today() function populating the Day column for the workplan is relative to the time zone of the…
-
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…
-
Phantom time zone switching
I recently created a helper sheet for the purpose of generating a multirow report from a much larger intake sheet. My helper report sheet is calculating the max entries on the main sheet, grabbing the last 50 rows, and looking for criteria matches that I have setup in helper columns in the report sheet. Its mostly working…
-
Identify Time Zone
Hi; I have a sheet that users captures information in, I have a column that records the modified date time, so the column is type of modified. Example Sheet1: Descrption , value , ModifiedDate abc , 123, 2024-01-01 10:50 <--- date time shown in Sheet ex GMT+2 Example Sheet2: Item Name , Value, ModifiedDate abc , 123,…
-
Issues with TODAY() and daily reporting
Hi there. In part of my duties, I run a report that shows activities entered on a form from yesterday. We do achieve "yesterday" by using the following formula: =IF(DATEONLY(Created@row) = DATEONLY(TODAY()) - 1, "Yesterday", "Not Yesterday") In using this formula we have noticed some alarming discrepancies. Reports with…