I’ve just discovered something rather worrying. We track our current task list on a spreadsheet which we call our ‘worklog’. It’s a central place for us to record everything that needs doing, whether it’s client work or business tasks, which we can both access. The idea is that we have a reliable place to track the jobs we need to do rather than keeping it all in our heads or on random bits of paper. We’ve been using it for a few years now and it’s worked really well for us. Until this morning…
What I discovered this morning is that a load of what was in there has been duplicated and a load of other stuff has gone missing (and not because they’re tasks we’ve completed). Eek! I’m trying to figure out if it’s something I’ve done but there’s so much wrong that I can’t see how I could have accidentally done it without noticing. Or is it because I was using some filtering to inspect different parts of the list? But filtering a spreadsheet shouldn’t mess with the data should it?
What’s going on??
I’ve spent the last hour removing duplicate entries and brainstorming anything that should be on there … but the whole point of it is that I shouldn’t have to remember everything so I’m sure there will be things I’ve missed. Might have to dig out last week’s backup, but of course that will only give me what was included a week ago, a lot of which we would have done anyway. Am also going through emails from clients to make sure I’m not missing anything there.
What a nuisance!