Skip Main Navigation
Page Content
This event has ended

Save This Event

Event Saved

Classroom Academy - Chicago


Wednesday, March 15, 2017 at 8:00 AM - Thursday, March 16, 2017 at 4:00 PM (CDT)

Classroom Academy - Chicago

Registration Information

Registration Type Sales End Price Fee Quantity
Group Rate
Smartsheet Academy price when you bring a colleague!
Ended $850.00 $0.00

Share Classroom Academy - Chicago

Event Details

This class is for new users and those who already use Smartsheet but want to learn to work more efficiently in a team environment. Using a combination of presentation, real-world scenarios and hands on activity, this class gives you the tools to successfully build and implement a workflow in Smartsheet and utilize features like reporting, web forms and cell linking to work more efficiently.

Course Outline

Smartsheet Essentials

                Set Personal Settings

                Creating new sheets



                Building Hierarchies

                Creating Columns



                Making alignment, font and color changes

                Assigning number formats

                Using format painter

                Applying conditional formatting


Web Forms

                Creating a Web Form

    Add & Remove Fields on a Form

                Change Field settings

                Deploy a Web Form



                Overview of collaboration tools/process

                Understanding Workspace and sharing

                User Management Overview

                Sending update requests

                Setting Notifications

                Using discussions


Cell Linking

                Consolidate data across sheets

                 Create inbound and outbound cell links

                 Remove cell links



                When to use Reports vs. Cell Linking

                Use the Report Builder tool

                Send and schedule reports


PM Basics

                Understanding the Project sheets

                Using Project Templates

                Create a project plan utilizing duration and dependencies

                Apply conditional formatting to a Gantt chart



Overview of Sights

Understanding Sight design

Create a Sight from Sheets & Reports


Using Formulas

                Referencing cells in Smartsheet

                Creating formulas with operators

                Copying formulas and changing the type of cell reference

                Using SUM and COUNT functions

                Using the CHILDREN function in hierarchies


Understanding Workflow

    Learn how to design solutions in Smartsheet by connecting multiple capabilities and components

                See how to diagram a workflow before you start building your Smartsheet


Scenario Activity

                Work as a team to build a Smartsheet solution



Apps & Integration

                Review the Smartsheet Apps gallery

    Understand the tools and apps available from the gallery to create charts, merge with Google     docs and Google Forms.





March 15th: 8am-5pm

March 16th: 8am-4:00pm

Light breakfast, lunch and snacks included both days. There will also be a happy hour after the first day.


A laptop computer with Wi-Fi access and power cord. Anything else you’ll need to be fully functional with Smartsheet.


If you wish to access 1871 during normal business hours between 7am - 6pm on weekdays, you can use any of the following elevators:

Orleans Street elevator bank ** This is the elevator bank closest to the 1871 entrance on the 12th floor

Main/Corporate elevator bank ** This bank is closest to the Merchandise Mart main entrance parallel to the Chicago River. Take these up to the 12th floor, exit the elevator bank, and take a right down the long hallway to 1871

Wells Street elevator bank


We recommend flying into the Chicago O'Hare or Midway International airports. Taxis, shuttles and rental cars are all available directly from the airport which you can use to get to 1871.

If traveling by train, bus or other transportation, let us know and we can provide more specific instructions.


There is discounted parking at the 210 N. Wells Self-Park Garage for 1871 tenants and guests!

$8.00 Monday - Friday, enter between 3:00pm - 11:59pm, out by 8:00am

$14.00 For up to 12 hours of parking anytime

Entering the garage:

For directions to the garage, please visit Entrances are located on Wells Street and Post Place (between Frankling Street and Wells Street.

Enter 210 N. Wells Self-Park and pull a "timed" ticket to lift the gate and park your vehicle. Take your parking ticket with you for validation at 1871 reception.

Exiting the garage:

Stop by 1871 reception to validate your parking ticket/ At the garage, insert your parking ticket into one of the pay stations in the ground floor lobby. You may pay your parking fee with any major credit card or cash. The pay station will return your paid ticket to yo, which you may then insert at the exit gate.


1871 is in close proximity to hotels at all price points, including:

SpringHill Suites Chicago Downtown/River North

Best Western River North Hotel

Holiday Inn Chicago-Mart Plaza River North

Hyatt Place Chicago/River North

Embassy Suites Chicago Downtown

Hotel Chicago

The Westin Chicago River North


For more information about 1871, please visit:

Have questions about Classroom Academy - Chicago? Contact Smartsheet

When & Where

222 W. Merchandise Mart Plaza, 12th Floor
Chicago, IL 60654

Wednesday, March 15, 2017 at 8:00 AM - Thursday, March 16, 2017 at 4:00 PM (CDT)

  Add to my calendar



Smartsheet is the world’s leading SaaS platform for managing and automating collaborative work. Over 90,000 companies, and millions of information workers, trust Smartsheet to help them accelerate business execution and address the volume and velocity of today’s collaborative work.


Sound hard? It’s not. In fact, according to Forrester, over 90% of our customers say that Smartsheet is easy to deploy and use, and 96% of them would recommend Smartsheet to a colleague.


Named to the Forbes “Cloud 100” list of the best private companies in cloud computing, and by Gartner as a “Cool Vendor”, Smartsheet is used by over 50% of the Fortune 500 and maintains rich data integrations with mission-critical applications from Microsoft, Google, Salesforce, Atlassian, and many others.

  Contact the Organizer

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.