BradEgeland.com
  • Welcome
  • Blog
  • Expertise
  • Resume
  • Software / Service Reviews
  • Contact
  • Videos
  • Books / White Papers
  • Mentoring Contact Form
  • Awards/Recognition
  • Templates & Downloads
  • Clients
  • Professional Services
  • Past Survey Results

Reinventing the Spreadsheet for Project Management

5/4/2012

2 Comments

 

There are literally thousands of Project Management tools on the market. THOUSANDS. While so many choices may seem like a dream, it can quickly become a nightmare. Each product comes with its own methodology, UI, structure, and functionality which makes finding, learning and using the ideal one for your project and team difficult.

It’s also why most people, after they search for their ideal purpose-built tool, return to old standby: the trusty spreadsheet.

Outside of power users who rely on tools such as Microsoft Project, spreadsheets are the dominant tool of choice (along with email) for coordinating work, gathering information, and updating tasks within teams. They're the instinctive ‘go-to’ tool because they're seemingly free, infinitely flexible to 'set up your way', and don't require IT involvement or approval.

If you send a spreadsheet to a colleague, client, or partner to edit or review, you’re confident he or she will be able to understand and update the work. But Project is too complicated - and expensive - for an extended team or clients to access directly. (If you’ve ever had to print Gantts or email PDFs, you know what I’m talking about.)

Look around your company. If you’re like most, the majority of your coworkers are using spreadsheets to manage all types of work -- projects, tasks, simple to-do lists, and ongoing programs. And, for the most part they work pretty well...

Until they don’t.

They don’t work when it comes to real-time collaboration with teams, adding automated workflows, finding out who’s made changes (and when), or housing related information like documents, graphics or PDFs. Plus, it gets complicated establishing cross-project dependencies, automating workflows, integrating schedules with your calendar - to name a few issues.

If you’ve ever tried to quickly roll up several spreadsheets into one master sheet with data automatically pulled from other sheets, or wanted dates on one sheet to drive a dependency on another, you’ve probably experienced “spreadsheet hell.” Linking cells across sheets is often challenging – and maddening. Links get broken when the source sheet is moved from the designated directory, and trying to figure out the source of a value, or whether other sheets reference data you are about to change, creates uncertainty and errors.

When we founded Smartsheet, we decided to keep what works about the spreadsheet, but fix the problems. It turns out that beyond data and number crunching, there hasn't been much fundamental innovation in spreadsheets in 20 years.  Even as the cloud has fundamentally changed the nature of enterprise apps, spreadsheet providers haven't responded. (“Why” they haven’t responded is worthy of a whole other post.)

Think of Smartsheet as a foundational SaaS app for managing work -- blending the most widely used and valued features of Project, SharePoint and Excel, with the collaboration capabilities of the cloud. Because it can be used to manage everything -- projects, marketing campaigns, HR onboarding, sales pipelines, manufacturing processes, and more -- it’s earned a seat at the table when companies evaluate productivity tools to deploy across the organization.

All within a familiar spreadsheet-like interface, you have the ability to attach files, view project dates in calendar or Gantt chart view, share the entire sheet or send individual rows to others via email to get updates, link cells across sheets, automate workflows and establish conditional formatting rules. It’s the tool that, as a former CEO of a global enterprise, I wish my teams had been able to use to manage work.
Picture

We’re betting the world doesn’t need another project management tool. It just needs to take what already works, and make it work better. We think we’re on the right track with our fresh alternative for managing work. Let us know what you think.
Picture
About the Author 

Brent Frei is the founder and executive chairman of Smartsheet.com. Previously he served as CEO and co-founder of Onyx Software Corporation and has also held roles at Intellectual Ventures, Microsoft and Motorola. He can be reached at brent.frei@smartsheet.com and you can read more about his thoughts at his blog at http://www.smartsheet.com/blogs/


2 Comments
appraiser assistant link
9/11/2013 10:47:08 pm

I will defiantly be putting this post in my favorites great post "Project spreadsheet" very informative post thank you for the share. I won't say that I completely agree, but then again I've never really thought of it quite like that before. We are starting a new initiative in the same niche as this blog.

Reply
vishal link
12/5/2017 06:11:05 am

Awesome Post!! I am impressed with your blog; you have shared the great information about project spreadsheet. It's beneficial and helpful information for us. Thanks for sharing this informative post.

Reply



Leave a Reply.

    Author:

    Picture

    Brad Egeland


    Named the "#1 Provider of Project Management Content in the World," Brad Egeland has over 25 years of professional IT experience as a developer, manager, project manager, cybersecurity enthusiast, consultant and author.  He has written more than 8,000 expert online articles, eBooks, white papers and video articles for clients worldwide.  If you want Brad to write for your site, contact him. Want your content on this blog and promoted? Contact him. Looking for advice/menoring? Contact him.

    Picture
    Picture
    Picture
    Picture
    Picture
    Picture

    RSS Feed

    Archives

    December 2022
    November 2022
    October 2022
    September 2022
    August 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    December 2021
    November 2021
    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013
    July 2013
    June 2013
    May 2013
    April 2013
    March 2013
    February 2013
    January 2013
    December 2012
    November 2012
    October 2012
    September 2012
    August 2012
    July 2012
    June 2012
    May 2012
    April 2012
    March 2012
    February 2012
    January 2012
    December 2011
    November 2011
    October 2011
    September 2011
    August 2011
    July 2011
    June 2011
    May 2011
    March 2011
    January 2011
    December 2010
    November 2010
    October 2010
    September 2010
    August 2010
    June 2010
    May 2010
    April 2010
    March 2010
    November 2009

    RSS Feed

Powered by Create your own unique website with customizable templates.