-
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,…
-
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…
-
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…
-
Set default timezone for Folders
I am managing about a thousand employees spanned across the US. All of these users are in 1 workspace, distributed into folders for each region. The idea is to set folder level default properties for time zone. Many times a user logs in and is defaulted to the incorrect time-zone because the laptop they're using has…