I have two columns that I have users enter data, formula combines it with the current modified date and time, then automations copy those rows to another sheet, so the history is preserved with the ti…
We have a daily task at the beginning of the day in which the first thing to do is to review and track the number of tickets accumulated outside of working hours from our system. The timestamp column …
I am looking to filter a sheet to show only entries made between 6AM yesterday and 6AM the day before yesterday. I tried using a helper column with the below formula to input a value that I could then…
We need the ability to record a time stamp for approvals. I found a workaround, but having it natively in Smartsheet like recording a date would be so much cleaner.
Hi, I'm having intermittent trouble with a move-row-to-another-sheet automation triggering off of a Record a Date automation AND a user selecting a drop down. Process- A user creates a PO and enters d…
We are working on a sheet to show the avg time spent on our tasks and we figured out how to time track as Smartsheet does not yet allow time tracking. Our solution was when someone selects "in progres…
I would like to get the last edited timestamp column as mm/dd/yy hh:mm:ss.ss as opposed to the standard mm/dd/yy hh:mm. For example I would like 08/13/24 13:53:47.89 instead of the normal way that sma…
My team is used to entering their time into Harvest which has a desktop timer. They start it when they begin a task and stop it when they are done. Although I've been told and read Smartsheet doesn't …
Hi, I noticed a strange glitch that occurs when using the Time() function. I'm basically trying to mimic a stop watch by calculating the duration of a start and stop entry utilizing the created date/t…