-
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…
-
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…
-
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!
-
Merged: Add 'Fortnights' to Gantt Timescale Settings
This discussion has been merged.
-
New! TIME function for formulas
Hey Community, Some of you may have noticed a new function in our Functions List last week… Introducing the TIME Function! This returns the time of day in 12- or 24-hour format from a given set of values. Syntax TIME(time_value, [ format ], [ precision ]) time_value — The value to create time with. Must be provided as a…
-
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…
-
Merged: Time Column
This discussion has been merged.
-
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…
-
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.