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

Monitor and Control Collaboration in Your Sheets

3/6/2019

 
by Dan Sills
​
Managing complex projects and processes requires precision and control. You never want to be caught off guard after someone changes data or removes key project details from your sheet.  

In order to prevent unexpected changes and stay on top of important updates to your work, you need a work execution platform that enables you to easily manage and track collaboration.

With Smartsheet, sheet owners and admins can improve transparency and rest assured knowing their sheet information is protected with these easy-to-use features.  
​

Stay Informed While Saving Time

When others are contributing to your sheet on an ongoing basis, it can be challenging to know if and when changes have been made. To ensure you don’t spend valuable time searching for these edits, you can turn on Highlight Changes.

This feature marks every cell, including attachments and comments, that has been changed in a specified period of time — such as the last hour, day, or week  — in your sheet.

The most common configuration for Highlight Changes is to view changes that have occurred since your last visit to your sheet. Sheet owners, admins, and collaborators can enable this feature to quickly see recent updates and changes to information. You can also turn on Highlight Changes to track modifications in your reports.
​
Picture
If you don’t have the time to directly monitor each sheet you manage, don’t worry. You can set up automated alerts to help you stay apprised of important changes — no code required.
​

Picture
Add multiple alerts to help account for different types of changes in your sheet, and configure them to meet your specific needs. For example, you could set up an alert to get notified immediately when a task’s status is changed to “At Risk.” Or choose to get a daily alert summarizing all the newly completed tasks in your project plan.
​

Picture
You’ll always be notified of new alerts in the Notification Center and can specify in your personal settings where else you’d like to receive notifications.
​

Track the Who, What, and When of Collaboration

With Highlight Changes and alerts, you can easily learn about a particular cell that has been updated. If you need more details, you can use Cell History to track all previous changes.

To begin using Cell History, right-click on the changed cell in your sheet and select “View Cell History” to get a detailed list of past edits.
​
Picture
The cell’s history includes each saved value, when it was saved, and who it was saved by. This helps you gain a holistic picture of cell data, easily locate changes, and revert details back to past status if needed.  
​
Picture
If you’re on a Business or Enterprise plan, you can also use Activity Log, found in the right panel, to get a granular view of all activity in your sheet.
​

Picture
Activity Log helps you keep track of major sheet changes and gain a better understanding of what areas of your sheet are being changed, and by whom.
​

Picture
Filter Activity Log by action type, collaborator, and date range, then download the log to a CSV file to closely examine what has happened in your sheet.
​

Picture

Selectively Protect Data in Your Sheet

You can now quickly understand changes that have already occurred in your sheet. But what if you want to prevent edits and deletions from occurring in the first place?
As the sheet owner or admin, you have the power to easily lock and unlock specific columns and rows in your sheet, while leaving others open to collaboration.
To lock a column, right-click on the column header and select “Lock Column” in the menu. You’ll see a lock icon appear above the first cell in the column. Click the lock icon at any time to unlock the column.
Picture
To lock a row, right-click on the row number and select “Lock Row” in the menu. A lock icon will now appear in the locked column to signify its status. To unlock the row, sheet owners or admins can simply click on the lock icon and it will open again.
​

Picture
Customers on select plans can also automatically lock and unlock rows based on a particular sheet change or a specific date and time. This way, you can manage stage-gate processes, align locking rows with key deadlines, and more.
​

Picture
Before locking a row or column in your sheet, consider your collaborators’ permission levels. Sheet owners and admins can continue to edit and even delete locked rows and columns. Sheet editors will be able to see locked rows and columns, but will not be able to edit them.
​

Collaborate With More Control

Collaboration is crucial in today’s fast-paced business landscape and critical for high-performing teams. By activating these features you can increase transparency, control, and accountability within your sheets — without stifling your team's innovation — and avoid getting stuck in a situation where data has been unexpectedly manipulated.  

These easy-to-use features help you to collaborate confidently knowing that your project, process, and the information in your sheets are secure. ​
​
Looking for more advanced ways to manage collaboration and data security in Smartsheet? Learn how these administrative features provide visibility and control, without sacrificing organizational innovation: 5 keys to Data Visibility and Control for Saas Solutions

Source: Smartsheet Blog
​
For Smartsheet Enquiry & FREE Business Trial

    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