-
Current TIme
Can you please add the current time in smart sheets similar to excel with =(Now) Formula. This would allow much more functionality to smart sheets with automations.
-
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…
-
How to change and edit default time in Gantt Chart ?
Hi all, I am trying to track time for each task in a gantt chart by using the formula (=Start@row + ""). This formula displays the date and time for each task as shown in the picture below. The problem is its assigning the default start time for a task to 8:00 am and I am not able to change it. The project settings section…
-
Invalid Operation Error on Dashboard but not on Report
Hello, I am using the Smartsheet Dashboard to communicate production status to colleagues. I have a widget on the dashboard meant to display the overall status of the manufacturing run by pulling the status of the last item on our task tracker (Condition37). The tracker is displaying the correct status, in this example…
-
Time taken to complete task
HI All, Apparently, i found this ticketing system fitting perfectly to my needs but i am stuck in the last 2 columns. End date and Duration(days and time taken). End date must come automatically show when status change to complete. Duration must show difference between created date+time and end date+time. how can i solve…
-
What is the best template to create a time tracking tool?
I need Task, Note, Priority, Ststus, Created by, Assignee, Start date and time, End date and time, Duration in days and time. And a dashboard to see an overview.
-
Merged: Feature Request: Duration Calculation from Date & Time Columns
This discussion has been merged.
-
how to resend an approval notification
I need to resend a approval notification if its not approved in 2 hours.
-
Column Formulas
Hello, I found this formula to convert time into military time but I would like the formula to be a column formula, so it automatically updates. It looks like I'm not able to convert it from a cell to a column formula however, any suggestions? =(VALUE(LEFT([Modified Time]@row, FIND(":", [Modified Time]@row) - 1)) -…