57NETWORK
  • About
    • VALUES & MISSION >
      • Integrity Declaration
      • PDPA
      • PDPA - Job Applicant
  • SMARTSHEET
    • Try Smartsheet For Free
    • BrandFolder >
      • BrandFolder + SMAR
    • Services >
      • Training For Success
      • Solution Building
      • Add-on Premium App >
        • Microsoft + Smartsheet
        • Docusign + Smartsheet
        • Dynamic View
    • Solutions >
      • Smartsheet For PMO >
        • Control Center
        • WorkApps
        • JIRA + Smartsheet
      • Smartsheet For Accounting Finance
      • Smartsheet For Legal Firm
      • Smartsheet For Marketing
      • Smartsheet For IT Operations
      • Smartsheet For Education
      • Smartsheet For Construction
      • Smartsheet For Healthcare
      • Smartsheet For Government
      • Smartsheet For Non-profit
      • Smartsheet For Software Development
      • Smartsheet For Sales
      • Smartsheet For IT PMO
      • Smartsheet For Professional Services
      • Smartsheet For Media Entertainment
      • Smartsheet For Telco
      • Smartsheet For SME
      • Smartsheet For Retail
      • Smartsheet For Energy and Utilities
      • Smartsheet For HR
      • Smartsheet For Tech Company
      • Smartsheet For Manufacturing
    • Customers Stories
    • Smartsheet Enquiry
  • Blog
  • CYBERSECURITY
    • Ransomware Mitigation
    • Prevent Email Fraud | Email Security
    • Installation Guide | Bitdefender Gravityzone
    • Patch Management
    • Nutanix Integration with Bitdefender Gravityzone
  • CONTACT US

How Smartsheet Uses Smartsheet: Saving an Hour a Day With Automated Actions

7/10/2018

 
by David Lotz
Everyone has heard the saying, “If only I had one more hour in the day.” Often we’re the ones saying it. Those of us with full lives know the value of an hour, and are always looking for ways to make the most of our time. Well, I’m excited to share a story with you about how I spent five minutes over the summer setting up Smartsheet automated actions and how doing so has saved me an hour each workday since.
​

A Manual Process Keeps Me Up At Night

Picture
Over the summer, I realized — after work hours — that I had forgotten to perform a task that others relied on, so I needed to sacrifice personal time to do so. We’ve all been there. We give up family time, dinner, kid’s sporting events, spin class, or even a relaxing night, to make sure work processes are running smoothly. In my case, I interrupted my sleep on a red-eye flight from Boston to Seattle to assign sales engineering resources to our sales representatives.

Let me explain. I manage one of Smartsheet’s sales engineering teams, and it’s my team’s responsibility to provide technical sales support for any rep who requests assistance. From basic product Q&As to complex proofs of concepts, sales reps can request help from my team, and they’ll receive it — if they meet minimum requirements. At the time of my red-eye flight, our request process looked something like this:
  • A sales rep requests sales engineering support on their sales opportunities through a form.
  • Smartsheet gathers the request form data into the Sales Engineering Assignment Backlog Queue.
  • The sales engineering manager reviews the request to ensure its validity, with the following in mind:
    • Is the information provided accurate and complete?
    • Is the deal up to date?
    • Does the request meet the minimum threshold requirements? 
  • The sales engineering manager confirms how long the rep has been with Smartsheet. (We provide additional support for newer reps who are still in training.) 
  • If any information is missing, the sales engineering manager reaches out to the sales manager and the sales rep over instant messaging, email, or a phone call to discuss what’s missing.
  • The sales engineering manager receives responses sporadically throughout the day and manually enters answers into the sheet.
  • Once data has been entered, the request is complete and sales engineering manager is ready to assign resources.

Due to the volume of requests from a team of over 100 sales reps, my time spent managing this process was totaling over an hour per day, not to mention the time taken away from my team in stand up meetings to triage the process as needed.
​

An Airborne Insight to Automate

That night on the plane — 40k feet in the air — I realized that Smartsheet could not only manage this process on my behalf, but it could do it more efficiently than I could. 

How? I could automate our process, to ensure we had the necessary information from our sales team, and more quickly react to requests. Smartsheet automated actions make  it easy to automate notifications, update requests, and approval requests, without a single line of code, complex formulas, or help from IT. 

So in 5 minutes, mid-flight, I set up the following rules in the sheet:
  • Send an automated notification: If the opportunity amount reflects $0, notify the rep (from the contact list column) that they will receive an assigned resource only once they have updated the opportunity with a dollar value.
  • Send an automated approval request: If the request is under our minimum support threshold, send an approval request to the sales rep’s manager (from the contact list column) to approve/disapprove a support exception.
  • Send an automated update request: If the request is missing any contextual fields describing what they need, send an update request to the sales rep (contact list column) to request the additional information.
  • Set conditional rules for automated actions: If the sales rep is under 2 months tenure (still in training), disregard above and accept all requests.

Our New Automated Process

Picture
The four actions above essentially removed all of my effort in the process prior to assigning my resources to opportunities.

The new process now operates as follows:
  • A sales rep requests sales engineering support on their sales opportunities.
  • Smartsheet pulls the request into SE Assignment Backlog Queue.
  • Smartsheet automatically checks to see that:
    • Request information is complete
    • Deal is current
    • Request meets minimum thresholds requirements
  • Smartsheet confirms rep’s tenure for trainee exceptions.
  • If any information is missing, Smartsheet reaches out to the sales manager or sales rep for approval exception or additional information respectively.
  • Responses are populated back into the sheet by Smartsheet automatically.
  • Everything is now ready to assign resources.

I spent about five minutes setting up the automated actions I put in place to make this process run on its own. With Smartsheet performing the above tasks on my behalf, I save an hour of manual effort every day. 
​

What Can Automation Do for You?

How much time do you spend emailing, calling, or chatting back and forth with your customers, employees, and coworkers? How many administrative steps do you deal with on a daily basis that could be automated? Collecting data, requesting updates, requesting approvals, and notifying stakeholders can all be automated with Smartsheet, so I hope you have an idea what you would do with the extra hour — or more — you get back each day. 

As for me, I’ll be sleeping on my next red eye. Don’t tell my boss...

Source: Smartsheet Blog
​
For Smartsheet Enquiry and FREE DEMO

    Author

    Writers and Bloggers from Smartsheet.

    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
    Meeting Management
    Meetings
    Meltdown
    Messaging Integration
    Microsoft
    Microsoft 365 Tips
    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
    Request Management
    Risk
    SAAS
    SaaS Adoption
    Scalable
    Scam
    SECURITY
    Security Control
    Silo
    Skype For Business
    Slack
    Smart Meeting
    Smartsheet
    Smartsheet Dashboard
    Smartsheet Mobile
    Smartsheet Portals
    SMARTSHEET TECHNICAL
    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

    Archives

    December 2022
    November 2022
    October 2022
    February 2022
    October 2021
    September 2021
    July 2021
    May 2021
    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

    RSS Feed

Malaysian accounting firm CKP improves both sales and productivity 30% by digitizing and automating with Smartsheet


Care line: +603-9212 0157

Leave us your inquiry

Contact us
Picture
Reach us via Whatsapp

Picture
Picture
57Network has been helping global companies in digitizing work management for greater transformation.
Copyright © 2022 57Network Consultancy Sdn. Bhd.
Company Registration number : 202001020346 (1376666-K) 
​(Formerly FIFTY SEVEN NETWORK since May 2015). All rights reserved.
 Privacy Policy ​ | ​Integrity Pledge | Site Map
Designed by 57 Web
  • About
    • VALUES & MISSION >
      • Integrity Declaration
      • PDPA
      • PDPA - Job Applicant
  • SMARTSHEET
    • Try Smartsheet For Free
    • BrandFolder >
      • BrandFolder + SMAR
    • Services >
      • Training For Success
      • Solution Building
      • Add-on Premium App >
        • Microsoft + Smartsheet
        • Docusign + Smartsheet
        • Dynamic View
    • Solutions >
      • Smartsheet For PMO >
        • Control Center
        • WorkApps
        • JIRA + Smartsheet
      • Smartsheet For Accounting Finance
      • Smartsheet For Legal Firm
      • Smartsheet For Marketing
      • Smartsheet For IT Operations
      • Smartsheet For Education
      • Smartsheet For Construction
      • Smartsheet For Healthcare
      • Smartsheet For Government
      • Smartsheet For Non-profit
      • Smartsheet For Software Development
      • Smartsheet For Sales
      • Smartsheet For IT PMO
      • Smartsheet For Professional Services
      • Smartsheet For Media Entertainment
      • Smartsheet For Telco
      • Smartsheet For SME
      • Smartsheet For Retail
      • Smartsheet For Energy and Utilities
      • Smartsheet For HR
      • Smartsheet For Tech Company
      • Smartsheet For Manufacturing
    • Customers Stories
    • Smartsheet Enquiry
  • Blog
  • CYBERSECURITY
    • Ransomware Mitigation
    • Prevent Email Fraud | Email Security
    • Installation Guide | Bitdefender Gravityzone
    • Patch Management
    • Nutanix Integration with Bitdefender Gravityzone
  • CONTACT US