Skip to main content

Smartsheet Tutorial: Getting Started


What is Smartsheet?

Smartsheet is a cloud-based work execution platform that blends spreadsheet functionality with project management, collaboration, and automation tools. Teams use Smartsheet to track and manage various types of work efficiently.

Getting Started

1. Creating an Account

  • Visit: www.smartsheet.com

  • Click “Try for Free” or “Sign Up”

  • Choose between an individual or business account

  • Complete the registration process

2. Understanding the Interface

Upon logging in, you'll see:

  • Home – Your dashboard overview

  • Templates – Access to pre-built sheet templates

  • Recent – Recently accessed sheets

  • Shared – Sheets others have shared with you

Creating Your First Sheet

Option 1: Using a Template

  1. Click “Templates” in the left sidebar

  2. Browse or search for a template

  3. Click “Use Template” on your chosen design

  4. Customize it for your needs

Option 2: Starting with a Blank Sheet

  1. Click the “+” button (top right)

  2. Select “Sheet” > “Blank Sheet”

  3. Name your sheet and click “OK”

Basic Sheet Components

Columns

  • Types: Text/Number, Date, Dropdown, Contact List, etc.

  • Add a Column: Right-click a column header → Insert Column Right/Left

Rows

  • Represent tasks or items

  • Use indentation to create task hierarchies

Cells

  • Hold your data

  • Can include formulas, attachments, or comments

Essential Features

1. Sharing & Collaboration

  • Click “Share” (top right)

  • Add email addresses

  • Set user permissions: Admin, Editor, Viewer, etc.

  • Add an optional message

  • Click “Share Sheet”

2. Attachments

  • Right-click a cell

  • Select “Attach File”

  • Upload from your computer or cloud services (Google Drive, Dropbox, etc.)

3. Comments

  • Right-click a cell

  • Choose “Add Comment”

  • Type your message and @mention teammates

4. Conditional Formatting

  • Select cells, columns, or rows

  • Click “Conditional Formatting”

  • Define rules and formatting (colors, icons, etc.)

Project Management Views

1. Gantt View

  • Go to View → Gantt

  • Set start/end dates

  • Visualize task dependencies

2. Calendar View

  • Go to View → Calendar

  • Choose the date field for display

3. Card View (Kanban)

  • Go to View → Card

  • Choose a column to group by for a Kanban-style layout

Automation Tools

1. Alerts & Notifications

  • Right-click a cell or row

  • Choose “Alert/Reminder”

  • Set alert conditions and timing

2. Automated Workflows

  • Click “Automations” in the toolbar

  • Use pre-built workflows or create custom ones

  • Define triggers and actions

Mobile App

  • Available on iOS and Android

  • Access and edit sheets anytime

  • Get real-time notifications on the go

Tips for Beginners

  1. Use templates to get familiar quickly

  2. Click the “Help” (?) icon for support

  3. Explore Smartsheet University for free training

  4. Start small—begin with simple projects

  5. Learn and use keyboard shortcuts to save time


Comments

Post a Comment

Popular posts from this blog

Information Governance vs Data Governance

Information Governance vs. Data Governance: Key Differences While Information Governance (IG) and Data Governance (DG) are closely related, they focus on different aspects of managing organizational assets. Here’s a simple breakdown of their differences and how they work together: 1. Definitions Data Governance (DG): - Focuses on managing **data as an asset**. - Ensures data is accurate, consistent, secure, and available for use. - Example: Defining who can access customer data and how it’s stored. Information Governance (IG): - Broader than DG, focusing on managing **all forms of information** (structured data, unstructured data, documents, emails, etc.). - Ensures information is used effectively, ethically, and in compliance with regulations. - Example: Setting policies for retaining and disposing of emails and documents. 2. Scope Data Governance: - Primarily deals with **structured data** (e.g., databases, spreadsheets). - Focuses on...
Post a Comment
Read more

Defensible Disposition - Purge; Don't splurge in legal costs!

Defensible Disposition: A Smart Strategy for Compliance and Security What Is Defensible Disposition? Defensible disposition is the legally sound, systematic process of discarding or destroying records, documents, and data that are no longer needed for business, legal, or regulatory reasons. By implementing this practice, organizations ensure compliance with legal requirements while reducing risks associated with unnecessary data retention. Why It Matters: Key Principles ✅ Compliance: Aligns with laws, regulations, and industry standards to avoid legal and financial penalties. ✅ Accountability: Establishes a clear audit trail to document every step of the disposition process. ✅ Security: Protects sensitive information by ensuring secure destruction, preventing unauthorized access or breaches. ✅ Efficiency: Eliminates outdated records promptly, reducing storage costs and streamlining data management. How to Implement Defensible Disposition 1️⃣ Identify Records – Determine which reco...
Post a Comment
Read more

Parser Generator

If you have a need for a parser generator for your applications say a SQL parser or an expression parser to plugin somewhere in your application, your obvious choices are ANTLR or JavaCC. ANTLR  (ANother Tool for Language Recognition) is a parser generator developed by Terence Parr, it is extremely versatile and is capable of generating parsers in multiple programming languages, but requires a run time library. The Definitive ANTLR 4 Reference is an excellent book to get into ANTLR. JavaCC  (Java Compiler Compiler) was written originally by Dr. Sriram Sankar and Sreenivasa Viswanadha. It is only capable of generating parsers in Java but doesn’t require a runtime library and the parsers it generates are very performant for an LL(k) parsers. Useful References: 1.   https://dzone.com/articles/antlr-and-javacc-parser-generators 2.  Work on JavaCC
Post a Comment
Read more