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/Numb…
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…
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 us…
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…
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 purpo…
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. …
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 …
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 i…
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/Qu…
