-
TIME Function - Which Time Zone?
I've been looking thru all of the posts regarding the TIME function and can't seem to find where it stated where the time is pulling from. Is it the user's PC time? Is it always Pacific time since that is the Smartsheet default time? How is the time change twice per year addressed? How does a company make sure that any…
-
Auto fill date and time emailing the wrong information?
Greetings, I set up a very simple form pictured below where someone could select their name from a drop-down and hit submit. On the back end, I have a column called date which enters the date and time of the submission. This information is then emailed to myself and a manager with all of the information in the row. When I…
-
Time Column
I noticed recently that the Time function has been added, it is greatly appreciated. However, with this new function it would be nice to have more robust support around it. I would love to see a new column format dedicated to time (kind of like the Date column). With that, allow a user on a form to select time from a clock…
-
Calculating Duration between Start Date and Completed Date including the time and date
Can anyone help how would I be able to calculate the time difference/duration between Completed date (includes time and date) and submitted date (includes time and date). By the way, both in Text/Number Column Type since both column were manually provided. I am not sure why I am getting "#INVALID OPERATION" error.
-
Formula help wanted
I'm trying to return a count of the number of cells that a) have a specific issue type and b) have an issue date within the last 7 days (I also want to duplicate the formula for 14, 30 and 90 days). I'm fairly new to smartsheets and formulas and I can't figure this out. I've managed the total count (i.e. the total count of…
-
Thanksgiving Dinner
I have a colleague looking to demonstrate the power of Smartsheet for project management and task management. She is trying to create an example of the task management and predecessor functionality using a typical American Thanksgiving dinner. The issue is Start and end date are only able to be calculated in days from what…
-
Unix/Epoch Timestamp to DATETIME format?
I'm trying to convert a Epoch Timestamp into a DATETIME format. I've had success using formulas getting it into a date, but am unable to get the time. Anyone have any insight on how to accomplish this? 1517577336206 as a timestamp example which I'd like to convert to 2/2/2018 8:15:36
-
Min/Max Time Formula
I am need to calculate the min and max time for a column. These times are entered manually (from forms) in the HH:MM format because created by and modified by columns are not appropriate for the purpose here. The times are entered into a form. These times are converted in a new column using the following formula:…
-
Is it possible to display 12-hour time format with AM and PM based on a 24-hour entry?
Is it possible to display 12-hour time format with AM and PM based on a 24-hour entry? For example, you enter "13:00" and it displays 1:00 PM
-
Sum cells based on multiple criteria with a timeframe requirement
I am working on trying to sum the time I spend across all my projects and want to sum different columns but only when they meet different criteria. Every formula I work through doesn't seems to work. I want to sum the Duration of Meeting IF the start date of a subject is within 5 days of the date in the green box that I…