
- RT @DEhlersGuam Four Tricks to Improve Your Memory | via @intuitquickbase http://t.co/ZzEMPHV3
Confessions of a recovering spreadsheet shuffler
I’ve been thinking about my last post and figured if I’m asking you to share your spreadsheet story why don’t I share mine too. I admit it, I was a shuffler. Don’t get me wrong. I like spreadsheets for number crunching — even making lists or schedules when I’m the only person working on a project. But, I’ve not a fan of the shuffling thing.
Prior to joining the QuickBase team I worked for several companies where I have been locked out of team spreadsheets that were posted on a shared drive – because someone else updated their information and left the spreadsheet open. That resulted in the rest of the team – or at least the most frustrated member – hunting that person down to close the spreadsheet so the rest of us could update our respective sections before our team meeting that day. That was definitely frustrating. Other times it was like an update roll-call. I’m done. Who’s going next? Ok, I’m done. Next. And on and on till we each got our updates in.
In the past I’ve also had to spend time consolidating spreadsheets. One time I had a list of leads from a seminar and I needed status updates from various sales reps. Because each sales rep could only see their own information I had to create about 10 versions of the spreadsheet – one per sales rep. Then email one spreadsheet to each rep requesting an update on the list of prospects. Followed by reminder emails and phone calls to get the information back, then consolidate that information back into one spreadsheet for a program report to management.
With QuickBase reporting on leads is so much easier. Our concierge team (think inside sales meets customer service) uses QuickBase to get their leads – each rep sees only their information – and I can easily report from the same system. I just pull a report of leads by their campaign code in order to get just my program. If I ever needed to remind the concierge team to update information I could set up an email notification to remind the whole team – instead of having to send out an individual email to each person.
I can’t tell you how nice it is to have all the information I need all in one system and accessible through an internet browser. I can pull reports from home, from the road. I don’t have to be in the office or using a VPN to do it.
One more confession.
You know when you send out a spreadsheet to a few people for updates and at least one of them messes with the formatting so you can’t just cut and paste information back into your master spreadsheet? Well, sometimes I’m one of those people who reformat a spreadsheet to make it work better for me. At my last job, I drove my manager a little crazy with my spreadsheet tweaking. But that’s all behind me now because with QuickBase I don’t need a spreadsheet, I can just create or edit a report in my team’s QuickBase application to see just the fields I need to see and then use grid edit to update my project information. I love grid edit – it looks just like a spreadsheet. I get to see the information I need the way I need it and I haven’t messed up any formatting for anyone else. And there’s no cutting and pasting, my information is updated along with my co-workers all in one place. No fuss, no muss and no frustrated managers.
Does any of this sound familiar?
Ok, enough about me. Tell me your story.
Remember the first five people to reply to my last post will receive a Starbucks gift card.
-
-
-
http://quickbase.intuit.com/blog/2009/04/09/621/
-
http://intuitlabs.com/
-
http://intuitlabs.com
-
http://www.tiffanyforsale.com
-
http://www.discountiffany.com
- Alison Green - Ask a Manager:
Ugh, yes, nail clipping! And calling unnecessary meetings! - CPAlady:
Also nail clipping
- Sbelcourt:
Is there a way you can set your ipad app for Quickbase to open in Full Site screen versus the mobile... - Anonymous:
@Chase: I don’t know what’s worse – a ridiculous comment like that or the standard... - Anonymous:
@Tom S, is that you? I actually quote you in my chapter on passion in my book, New Job, New You. Thank...






Kathleen Lamphier Reply:
April 9th, 2009 at 6:44 pm
Hi Kevin,
Thank you for sharing your story. The Alternate Energy Field sounds very interesting. And wow, being able to do the same amount of work with half the staff by using QuickBase is great! Thanks for sharing that information.
Can you tell me a little more about why you needed a project management application that was totally tailorable? What were some things that a packaged application couldn’t do for you?
-Kathy
[Reply]
turner Reply:
April 10th, 2009 at 7:18 am
I’ve been thinking about my last post and figured if I’m asking you to share your spreadsheet story why don’t I share mine too. I admit it, I was a shuffler. Don’t get me wrong. I like spreadsheets for number crunching — even making lists or schedules when I’m the only person working on a project. But, I’ve not a fan of the shuffling thing.
Prior to joining the QuickBase team I worked for several companies where I have been locked out of team spreadsheets that were posted on a shared drive – because someone else updated their information and left the spreadsheet open. That resulted in the rest of the team – or at least the most frustrated member – hunting that person down to close the spreadsheet so the rest of us could update our respective sections before our team meeting that day. That was definitely frustrating. Other times it was like an update roll-call. I’m done. Who’s going next? Ok, I’m done. Next. And on and on till we each got our updates in.
paralegal jobs uk
[Reply]
turner Reply:
April 10th, 2009 at 7:21 am
Hi,
I’ve been thinking about my last post and figured if I’m asking you to share your spreadsheet story why don’t I share mine too. I admit it, I was a shuffler. Don’t get me wrong. I like spreadsheets for number crunching — even making lists or schedules when I’m the only person working on a project. But, I’ve not a fan of the shuffling thing.
paralegal jobs uk