My columns are set up as follows:
1. Project
2. Frequency performed (one off/daily/weekly, etc)
3. Details
4. Direct hyperlink to project
[I'm an admin to a hospital vp and also support our patient care services dept, which includes all our nurse managers.
Basically, I'm all over the place: in meetings, planning events and travel, reconciling expenses, preparing reports and tracking (nagging) others for their action items' progress, correcting time cards, updating policies, etc etc.
I perform my job with very little supervision (just the way I like it) and must stay very organized. To be honest, I don't feel that I have a very good memory, so keeping a spreadsheet like this is a lifesaver.
It will impress the hell out of your supervisor when you are able to quickly find whatever they ask for, make yourself indispensable...
"What would we ever do without you, insertusernamehere!?") and almost guarantees you excellent pay raises.]
BONUS LPT: Use Microsoft Outlook's many tools to color coordinate and automatically sort your emails so that you aren't "touching" your emails over and over.
When an email arrives, I click to sort it in my Inbox as one of the following (plus others directly related to ongoing projects). Note: when sorted alphabetically, the categories sit in your inbox in order of importance.
Attention (red)
Delay-to do (yellow)
Delay-waiting (orange)
Yet to come (gray)
I also use color coded calendar categories so that my supervisor and I can see what we have going on at a glance:
Phone/conf calls (green)
Birthdays/anniversaries (purple)
PTO or outside meetings (black)
Important reminders (red)
Meetings (blue)
Hope this is helpful to someone. 🤓