-
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.
-
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)) -…
-
Cycle Time - Converting minutes to hours and minutes
Hello, I am trying to convert total minutes to hours and minutes but am having problems. I am using the formula below, but in some instances it returns a number with 4 digits in the seconds column. =INT([2023]@row / 60) + ":" + MOD([2023]@row, 60)
-
Help with time calculation (total hours)
I'm desperate for calculating hours help 😩 I've created a report sheet for incidents in our department. These are submitted using a form and the incidents are managed by several people. The idea is that depending on the severity of the incident, we should alert the incident owner so they can update the status and leave…
-
"Substitute" Column Formula Inconsistency
Hello, I am using the column formula below to extract the time from the "Created Date" column. =SUBSTITUTE([Date Submitted]@row, DATEONLY([Date Submitted]@row), "") However, you can see in the screen shot below that it doesn't always work. Is this a bug?
-
Elapsed time from a system column to the current datetime
Hi guys, I need some help to calculate the hours and minutes have elapsed from a system column (which is the ticket creation date) to the present date, not sure if it is possible to use TODAY() formula. Here are some screenshots of what I have so far, but seems like the minutes calculation is not working. The ultimate goal…
-
Office Clinic Patient Registration Booking
I am looking to set up a booking system for a downtime project to be able to use in our offices (clinics). I would like to be able to see the rooms for that location and the availability for each time slot. Ultimately if a patient checks in they would then be assigned to a room during registration. 2. Is there any…
-
Trigger a Checkbox when the System time matches a Service Level Time
Our internal customers can submit requests to expedite a process to meet a customer's deadline. These requests should be processed within three hours of receipt. Currently, I can add three hours to the creation date and time to fill in a Max SLA Field. Once that future time (Max SLA) is reached (matches the system time), I…
-
Can you use the TIME function to calculate the difference i.e. duration between values in 2 columns?
Hello, I've previously used the many pointers and guidance on the forums for coming up with solutions that help calculate time and duration between columns using a range of different helper columns.. I've never used the TIME function before, but I'm hoping I can use this to try and save having to add multiple helper…
-
Time Difference Calculation Using Military Time
I am struggling coming up with a time difference calculation smartsheet. I have two text fields, one called From and the other To. Users are to input time in a military format (exp: 07:00, 13:00) and then the calculation should fill my Duration field with the difference between those two times. Can this be done without…
-
Feature Request - Authoritative TODAY() functions
Context All Automations run on sheet owner time (in my case, Pacific time). Sheet columns generally use universal / UTC time in the backend (i.e. Created, Modified columns – so the time stamps are authoritative). However, the Today() function populating the Day column for the workplan is relative to the time zone of the…
-
How do I write this formula?
I want to write a formula that calculates the number of days we have from today until we run out of stock. I have: The number of Laptops Available The Avg Monthly Hires and I know we give out laptops at NEO every other Monday (Next one in February 17, then March 3rd, March 17th so on) How can we tell the number of days…
-
Formula to track training by hours and minutes not days
We need to track all training by hours and minutes, not days, and I can't find a solution to be able to calculate this with a formula. Anyone able to help? Thanks!
-
IF(AND With Time
Hello Brilliant People! I'm stuck on this IF formula incorporating time and multiple conditions: *Quick detail, I work in construction and this is regarding a form my guys use twice a day to do a safety walk of the job site. Both safety walks have a cut off time determining task compliance, and there are multiple job…
-
Calculating Difference between start time and end time
Hello. I realize there are already several threads on calculating time. I've reviewed the ones I've found and seem to be missing something basic in th setup of my grid sheet…. Here is what I'd like to do: I am creating a sheet that will be tracking: load times, delivery times, and travel times for our drivers. Ideally I'd…
-
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…