• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Creating a timestamped Excel task log

M

mooglekit

Senior member
Hey Guys,
Any way to create a spreadsheet in Excel which timestamps each new entry and then sorts those from most recent to oldest? I'm trying to create somewhat of a task log which takes a text entry saying what was done, or changed and want to be able to keep track of when those tasks were finished or changed. Thanks for any help.
moogs
 
Excel is a spreadsheet program and thus is not going to autosort after each entry nor does it have a date/time function that can be linked to a cell of data...You can however use the NOW() and TODAY() functions to display the current date/time...but when used in conjunction with excel formulas all of them get updated at one time usually...

If you want to create something like that you'd be better off using an Access application...give ya the abilities of excel with the power of access to do all the timestamping and sorting you want 😀
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top