-
Merged: Auto timestamp
This discussion has been merged.
-
Time stamp challenge
I use "the copy row" function to a new sheet workaround for a time stamp if a checkbox is checked. In my original file I use the VLOOKUP funktion to get date and time. So far that workaround is working. My problem is, that in my file where I collect all this "checked" rows, the modified date always changes (to actual date…
-
Notifications sending too early
Is there a way to set the time the notifications send? Our associates are getting notifications at 2 and 3 in the morning.
-
Issue with Syncing Smartsheets to Outlook
We're very excited to have discovered the feature which allows us to sync Smartsheets to Outlook. However, when we import the calendar, the events are loading as all day events (see calendar to the right). I'm guessing we have done our "time" column incorrectly, but aren't sure how to fix it. Thank you for your help!
-
How do I find/calculate the available (latest) date from multiple rows WHERE there is a condition
Intent: Calculate date team member is available I have a resource planning sheet, which lists a number of activities (by row) for team members. Each row describes the team member, activity, the status, and the start and end date. How do I find the latest end date for each team member, where there activity is 'In Progress'?…
-
Date+days not calculating correctly
Hi all, I need to add 21 days to a date referenced in another cell. Ex: 10/15/23 When I use this formula: =DATE(YEAR([Projected Start Date]@row), MONTH([Projected Start Date]@row), (DAY([Projected Start Date]@row)) + 21) I receive an #INVALID VALUE If I hardcode the date into the formula (=DATE(2023, 10, 15)+21, I return…
-
Two digit format for hh:mm:ss
Hi all, I researched through numerous posts and threads regarding calculating time but just couldn't figure out one last part. I hope it's an easy one for some experts here. I am trying to calculate the average of a range of time and display it in hh:mm:ss format. By reading through the posts here, I was able to figure out…
-
Calculating Time Duration with In/Out
Hello, I have reviewed several posts on calculating time worked from in/out time entries. I tried to use one of the formulas previously presented (see screenshot), but I keep getting an Invalid Operation error. If it helps, I am trying to calculate time worked using the 12 hour format.
-
Merged: Time Tracking
This discussion has been merged.
-
How do I calculate the sum of a length of time column in the Sheet Summary
I want to be able to calculate the total length of time of all the video files in a sheet for the Sheet Summary. (to then be able to report across multiple sheets, populate in a dashboard etc). These are not formulas and there is also no start or end time as this is the length of a video, not work time. Also, as these are…