-
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…
-
Nested child cards/time management
Hi everyone! I need help with a couple of things please. For our monthly KPI reports, we have to track how much time we spend on each task. How do I add subtasks to be the main task (i.e. total hours spent on that task overall) I would need to see total hours spent on the task overall and total hours spent on each sub-task…
-
Time and Date calculation
Is there a way to show how many hours passed from the time the form was submitted/created to the running/current time and date? I am trying to show the running hours lapsed while the entry submitted is still in the "Pending Status" I have the following column available I wanted to show the current duration in hours that…
-
Average Time for Chart
Hi all, I'm having trouble calculating an average duration of a time to resolve per quarter. This information is in two columns on a sheet: Time to Resolution (data type Duration) and Incident Year/Quarter (dropdown list). I've looked in the time articles and downloaded the formula template, and still missing the right…
