Skip Main Navigation
Page Content

Save This Event

Event Saved

Smartsheet Academy - March 15-16, 2017 Chicago

Smartsheet

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

Registration Information

Registration Type Sales End Price Fee Quantity
Early Bird Registration
Smartsheet Academy price $1050 - $100 discount for those who register prior to March 1, 2017.
Mar 1, 2017 $950.00 $0.00
Group Rate
Smartsheet Academy price when you bring a colleague!
Mar 15, 2017 $850.00 $0.00

Share Smartsheet Academy - March 15-16, 2017 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

                Navigation

                Import

                Building Hierarchies

                Creating Columns

 

Formatting

                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

 

Collaboration

                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

 

Reporting

                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

 

Sights

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.

 

 

EVENT INFO

DATES/TIMES

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.

WHAT TO BRING

A laptop computer with Wi-Fi access and power cord. Anything else you’ll need to be fully functional with Smartsheet. If you do not have access to a laptop computer please reply to this email to notify us.

ELEVATORS

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

TRANSPORTATION

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.

PARKING

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 http://www.210nwells.com/directions. 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.

ACCOMMODATION

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: http://www.1871.com/

Have questions about Smartsheet Academy - March 15-16, 2017 Chicago? Contact Smartsheet

Save This Event

Event Saved

When & Where


1871
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

Organizer

Smartsheet

Smartsheet.com, a leading Software as a Service (SaaS) company, offers an enterprise-ready cloud app for work management and collaboration. The award-winning tool is trusted by more than 40,000 businesses and millions of users in over 160 countries.

  Contact the Organizer
Smartsheet Academy - March 15-16, 2017 Chicago
Things to do in Chicago, IL Class Business

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.