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.
Set personal settings
Creating new Sheets
Making alignment, font and color changes
Assigning number formats
Using format painter
Applying Conditional Formatting
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
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
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
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
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
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.
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 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 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.
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
The Westin Chicago River North
For more information about 1871, please visit: http://www.1871.com/