Classroom Academy - Chicago
$850 – $950
Classroom Academy - Chicago

Classroom Academy - Chicago

Event Information

Share this event

Date and Time




222 W. Merchandise Mart Plaza, 12th Floor

Chicago, IL 60654

View Map

Friends Who Are Going
Event description


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 web form

Change field settings

Deploy a web form


Overview of collaboration tools/process

Understanding Workspaces 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 Workflows

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

Build and manage a Workflow in Smartsheet

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-4pm

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:

Share with friends

Date and Time



222 W. Merchandise Mart Plaza, 12th Floor

Chicago, IL 60654

View Map

Save This Event

Event Saved