Time Calculation
Discussion List
- 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 …
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.. …
- 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() formul…
- Hello All, I'm a new user to Smartsheet and am trying to figure out the formula for calculating time. I have a start time column and an end time column and am trying to figure out the formula to calcu…
- 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…
- 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 th…
- 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 …
- 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 aut…
- 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 …
- 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 safe…
