57NETWORK
  • About
    • VALUES & MISSION >
      • Integrity Declaration
      • PDPA
  • SMARTSHEET
    • Training For Success
    • Use Cases >
      • Project Management | For PMO
    • Add-on Premium App >
      • Dynamic View
    • Customers Stories
    • Tips and Trends
    • Smartsheet Enquiry
    • 2017 Enterprise Collaboration Report
    • Resources >
      • Forrester Report Request
      • Manufacturing Industry Webinar
      • Construction Industry Webinar
      • Retail Industry Webinar
    • Press Release | Smartsheet >
      • Top Colleges & Universities Use Smartsheet
  • Trial
  • CYBERSECURITY
    • Installation Guide | Bitdefender Gravityzone
  • CONTACT US

5 Reasons Customers Manage Work in Smartsheet Over Google Sheets

8/17/2017

 
Picture
Steve Brown on October 20, 2016

Talking with customers, I’m constantly amazed by how they use Smartsheet. They use us to launch rockets, open retail stores, build skyscrapers, plan world-class events, improve processes, and everything in-between.
​
Recently, a friend asked me why people shouldn’t just use Google Sheets instead of Smartsheet? Fair question despite the fact that he draws his paycheck from Google. After sharing with him that Google itself is a large Smartsheet customer, I offered the following five reasons customers manage work in Smartsheet over Google Sheets.
 
First, a confession....I like Google Apps. I use them often in my current job. This is being written in a Google Doc. If you're looking for someone to hate on Google, I'll disappoint.

1. Simple, Intuitive, and Visual 

Spreadsheets are popular for more than just formulas and pivot tables. Millions use them every day to organize work and ideas that otherwise pollute inboxes, minds, and notebooks. It’s from this popularity that Smartsheet was born with a spreadsheet-like interface that’s instantly familiar.

Where Smartsheet starts to differentiate from Google spreadsheets is on the visual front. Three features I hear customers cite frequently are hierarchy, column types, and image handling:

Hierarchy - Smartsheet enables you to add hierarchy to rows with a simple click or keystroke.  On the surface this gives your information highly-visual organization through indented rows and collapsible sections. That’s not all - you’re giving your information relational meaning. You can actually write formulas that call on parent-child relationships to roll up information nested in one group or another.  

In Google, use spaces to show hierarchy and write formulas to roll up information. No expanding or collapsing.

Picture
Smartsheet let's you create, expand, and collapse groups, and write formulas based on hierarchy.
Picture
Column types - Smartsheet columns have special properties that make your sheets easier and more powerful to use. You can decide whether a column should contain text, numbers, a contact list, a date, a dropdown list, a checkbox, an auto-numbering sequence, and even symbols. 

Symbols are one column type I use everyday because symbols quickly convey information. Smartsheet has numerous built-in symbols that you can add to a cell by selecting them from a drop-down. You can even use simple formulas to have them change automatically.

Choose from dozens of symbols to convey everything from priority to status.
​
Picture
Images - Ever been bothered when you resize columns in your sheet and your images don't resize with them? While Google drops images right on top of a spreadsheet or requires a function call to tie it to a fixed location, Smartsheet snaps them right into a cell. Want to move or resize the row or column? Smartsheet resizes and moves the image for you. Need to download the image? You can do so in full fidelity.

In Google, write formulas to reference images stored somewhere else.
​
Picture
In Smartsheet, right-click on a cell to add an image, which Smartsheet stores in full fidelity.
Picture
2. Streamline Everyday Collaboration 

Google has good collaboration on documents. It’s easy to comment, share, etc. That’s important because for information workers today the true measure of productivity is how well they collaborate with others to get stuff done. And getting stuff done is much more than document collaboration. It’s about planning, communicating, organizing, prioritizing, creating, and coordinating - everything involved in working with others.  

A great example of how Smartsheet promotes collaboration is with the ability to request updates from others. 

Smartsheet streamlines the request process. Say you need updates to only three specific cells in your sheet. Using Smartsheet, it’s obvious to recipients what they need to do. They provide their updates in an intuitive form that shows only what’s requested. Updates post directly to the sheet. 
​
Picture
3. Visualize Your Work

Recently I spoke with a customer who coordinates hundreds of marketing campaigns. She personally prefers to see campaigns stacked in a list with timelines, but said that others prefer more visual views. Views like Kanban boards made popular by apps like Trello.  

Smartsheet solves for this through its Card View. Changing views is as simple as clicking a button:

I’ve  created a list of simple tasks to use as an example.

Picture
Then, using the same list, I click on the Card View button for a Kanban-like view.
Picture
That’s it. Three ways to view and interact with one list.  

4. Reduce the Reporting “Tax”

The burden of reporting - collecting and collating inputs across numerous stakeholders - is taxing on everyone involved. Smartsheet eliminates or reduces this tax.  

You can create a report that rolls up information directly from multiple sources. Imagine that you’re an executive who needs information from multiple important initiatives. The design team is using one sheet. An engineering team another. HR, yet another. And so on. A Smartsheet report can look across all of those initiatives and show everything in one report.  
The Report Builder walks you through report generation step by step.
​
Picture
This example report is pulling information from seven different sheets with seven different sheet owners.
Picture
The benefits of Smartsheet reporting go beyond auto-compiling reports. Reports are also real-time and bi-directional. Every change made in a report is reflected in the underlying source sheet.

Now, you might be able to code something that mimics this in Google Sheets. It’s beyond my skillset, and from what I can tell it involves a lot of advanced query, vmerge, and import functions.   

5. See How It All Works Together

I’m impressed with the new Google Sites - you can make beautiful public websites and internal wiki-like pages. Smartsheet Sights are different however. They are designed from the ground up to enhance the value of information already created in Smartsheet, by exposing it in better, even more useful ways.

Sights help you show information across your sheets and reports at the level of detail you choose.  You can surface a sheet or report, summarize key information in a summary list, or even show data, like a key metric, contained in an individual cell.  

Picture
Check out our Smartsheet Sights Gallery to see more examples.

To Wrap It All Up

These are just five of the many reasons that millions of informations workers are managing their work in Smartsheet. 
  1. Smartsheet is simple, intuitive, and highly visual.  
  2. It helps you streamline collaboration with integrated features like Update Requests.  
  3. You can consume and share information the way you want to, using Card, Grid, or Gantt Views. 
  4. The effort required to report on and share information is minimal with things like Reports.
  5. Smartsheet Sights showcase the valuable information you already have in Smartsheet, with no coding required. 

So, give Smartsheet a try if you haven’t already. 


Source: Smartsheet Blog

Tell me more about Smartsheet

    Author

    Writers and Bloggers from Smartsheet.

    Archives

    December 2020
    October 2020
    July 2020
    November 2019
    September 2019
    July 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
    January 2018
    December 2017
    November 2017
    October 2017
    August 2017

    Categories

    All
    2019
    360 Reviews
    Abacus
    Accelerate
    Accountability
    Accountabillity
    Administrative Control
    Adoption
    Agile
    Agility
    AI
    Alert
    Artificial Intelligence
    Asset Management
    Authentication
    Automation
    Automation In Workplace
    Autopsies
    AWS
    Barcode Inventory
    Better Communication
    Better Decision
    Borderless Team
    Bottom-Up
    Brainstorm
    Business
    Business Leaders
    Business Moves Fast
    Business Software
    Card View
    Chat
    Chatbot
    Chatflow
    CIO
    Clear Vision
    Cloud
    Collaboration
    Collaborative Work Management
    Comfort Zone
    Competitive Advantage
    Compliance
    Construction
    Converse.ai
    Creativity
    Critical Path
    Cross-functional
    Csuite
    CTO
    Customer Experience
    CWM
    Dashboard
    Data Control
    Data Privacy
    Data Security
    Data Visibility
    Decision Making
    Delegation
    Digital Technology
    Digital Transformation
    Direction
    Efficiency
    Email
    Employees
    Employee Spotlight
    Empower
    Engage
    Enterprise
    EVENT
    Flexible
    Future Of Work
    Gantt Chart
    GDPR
    Google
    Google Hangouts
    Google Maps
    Google Sheets
    Grow
    Hacker
    High Value Work
    Hours Saved
    HP
    Information Access
    Innovation
    Issue Tracker
    IT
    IT Team
    Kevin Carroll
    Killer App
    Location Capture
    Location Sharing
    Logged Locations
    Luca Pacioli
    Machine Learning
    Make Better Decisions
    Maximise Productivity
    Maximum Value
    Meetings
    Meltdown
    Messaging Integration
    Microsoft
    Microsoft Excel
    Microsoft Teams
    Mobile
    Navigation
    New Interface
    Old Systems
    Onboarding
    Permissions
    Phishing
    Portals
    Portfolio Reporting
    Post-mortem
    Praerit Garg
    Productive
    Productivity
    Project Management
    Project Managers
    Project Tracking
    Quality
    Quantum
    Real Time Information
    Real-time Information
    Risk
    SAAS
    SaaS Adoption
    Scalable
    Scam
    SECURITY
    Security Control
    Silo
    Skype For Business
    Slack
    Smart Meeting
    Smartsheet
    Smartsheet Dashboard
    Smartsheet Mobile
    Smartsheet Portals
    Spectre
    Speed
    Spoofing
    Spreadsheet
    Stay Connected
    Streamlined Processes
    Successful
    Teamwork
    Team Work
    Technology
    Time Saved
    Top-Down
    Track Submissions
    Transform
    Transparency
    Trust
    Upgrading
    Visibility
    Waterfall
    William Oughtred
    Work Anywhere
    Work Better
    Work Collaboration Platform
    Work Communications
    Work Execution Platform
    Workflows
    Workplace
    Workplace By Facebook
    Workplace Messaging
    Work Smart

    RSS Feed

Picture
Reach us via Whatsapp

Leave us your inquiry

Contact us
Care line: +603-9212 0157
Picture
Copyright © 2021 57Network Consultancy Sdn. Bhd. (Formerly FIFTY SEVEN NETWORK). All rights reserved.
 Privacy Policy ​ | ​Integrity Pledge | Site Map
Designed by 57 Web
  • About
    • VALUES & MISSION >
      • Integrity Declaration
      • PDPA
  • SMARTSHEET
    • Training For Success
    • Use Cases >
      • Project Management | For PMO
    • Add-on Premium App >
      • Dynamic View
    • Customers Stories
    • Tips and Trends
    • Smartsheet Enquiry
    • 2017 Enterprise Collaboration Report
    • Resources >
      • Forrester Report Request
      • Manufacturing Industry Webinar
      • Construction Industry Webinar
      • Retail Industry Webinar
    • Press Release | Smartsheet >
      • Top Colleges & Universities Use Smartsheet
  • Trial
  • CYBERSECURITY
    • Installation Guide | Bitdefender Gravityzone
  • CONTACT US