Smartsheet

Pros

- Ease of Use - No need to involve programmers to create custom solutions
- Versatility - customizable sheets and dashboards for different departments and needs
- Support - AMAZING user forum, help pages, support department

Cons

Row and cell link limitations - I bump up against the cell link limitations often, although I can work around them by saving my metrics into multiple sheets.

Pros

Very good with basic project management features. Kanban is great, and you can view data multiple ways (kanban, gantt, table). The workspaces tool is cool, it's a good way to organize reports and data. Reports are great for showing users only the data they need, and keeps them out of source data tables. There is also good cross sheet functions like you would see in excel.

Smartsheet is also one of the most widely available tools to be integrated with. Tools like Zapier make it easy to integrate with, and you can also upgrade to a live data connector to visualize your data in a tool like tableau.

Cons

Features can be way behind. They just introduced features like pivot, and group to analyze data. Their internal workflow tools are behind what's commonly available in the marketplace. And if you want to use a separate workflow tool like Zapier, you will pay to use it. Their row limit just went up from 5,000 to 20,000 in a sheet in 2020, which was always a limit of how much we could scale the tool.

Pros

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.

Cons

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.

Pros

SmartSheet is a tool setup in such a way the it can be tailored to your organisation and used for multiple functions, by multiple divisions. The speed at which they are improving the platform with new functions and features is beyond amazing. Any small to medium size business trying to improve in project management, ICT management, customer service, task management, resource management, team management (the list goes on) would largely benefit from investing in SmartSheet. The ROI is incredible and the ease of rolling it out through an organisation is simple due to the intuitive UI.

Cons

The only downside I see with SmartSheet is the permission levels. These could be improved with the ability to share sheets in bulk rather than just at a workspace or individual sheet level.

Pros

Intuitive and fit for use given the industry and specific use cases

Cons

A bit difficult to collaborate directly in the system - i.e. mentions and comments