Smartsheet

This is the tool we use every day, every hour, to track all of our enrollments and clients. Our team monitors enrollments and other CRM tools don't give us the flexibility to track multiple events and data points. It's Excel but on steroids with multiple functions and features. We're using it more and more every day for reporting up to our management team on progress for our client events.

I'm not so good at the formulaic side of things and making sheets talk to each other, or building a dashboard, is not an intuitive process. There are not step by step instructions or visuals which is something I need personally. It's a lot of trial and error in getting things set up. When I first started, it was very expensive to work with someone who helped build the infrastructure base and looking back there are many things I'd have done differently if I'd understood it a little better. A lot of the consultation time was wasted in trying to get the person to understand what we were trying to achieve.

The tool is more than a project management tool. I use it to manage my department's budget, collaborate with internal and external team members. I like that I can access it from anywhere I am

Could use some of the more advanced functionality like automatically keeping track of KPIs such as Earned Value, schedule variance, etc. I would like it if I could "play" with effort vs duration without affecting the main baseline until I am ready and obviously, I would like to keep history of baseline changes

Smartsheet is my preferred software for Gantt charts, and for quick & simple spreadsheets. The formatting features are especially effective, such as easy indenting and quick checkbox options that can be used with formulas. Gantt charts on Smartsheet are quick and intuitive with all the options I would like to have. Dashboards can be a nice way to have an overview with links to different sheets if you have a project with several documents, and are willing to spend the extra time and money to set it up.

The big Con with Smartsheet is that it lacks the in-depth features of similar spreadsheet software that is also usually freely available.
Conditional formatting the way you would like it to work can take a surprisingly long time, as it can take many conditions (often one per column per action) to accomplish what you would think would take a handful.
Automatic email sending from sheets sounds great but is still not very fleshed out, and options are pretty limited.
Complex formulas usually need to be done in several hidden columns or they can end up taking large paragraphs of hard-to-edit text and numbers due to lack of formula options. This can also make complicated spreadsheets pretty slow.
Bugs occur infrequently, but make me prefer to double check important sheets.

Many are using MS Excel to track projects and orders... If this is your world, then you have to try out Smartsheet! Excel like User Interface that does a whole lot more. Schedule reminders, automate tasks, work flow, and the list goes on... and yet, the with the straightforward simplicity of a familiar EXCEL like environment. Other Project Management tools are great, but for those of us that like the EXCEL look and feel, you will find Smartsheet super easy to adopt and you will love the awesome features it provides. Smartsheet also regularly sends out tips on how to improve your processes and ideas on how to use it in many other ways.

When compared to some of the other solutions like Trello, BaseCamp or Asana, Smartsheet may not be as 'flexible' since it adheres to an Excel like user interface. Maybe this is because of my lack of knowledge in all aspects of Smartsheet's features? Overall, there's not much I don't like about Smartsheet for the way me and my team has to use it.