In May, we explored all the cool import features that Grist offers, such as incremental imports, merge fields, and formula transformations.
00:07 Questions submitted during sign-up
05:55 Webinar overview and sample use case
06:45 Importing to create a new document v. importing into an existing data
07:18 Importing from Google Drive
08:50 Importing to create a table with columns from a spreadsheet
10:30 Importing only one table from a spreadsheet with many sheets
12:39 Importing data incrementally into an existing table
13:05 Column mapping when importing to existing tables
14:39 Extracting month, year from date columns
17:44 Summarizing data by a column, such as month
18:52 Merging data on a field to avoid duplicates & update existing records
26:37 Transforming data during import with a formula
30:52 Summarizing by multiple columns
32:53 Game time! Flashcards about Grist built in Grist: https://docs.getgrist.com/ffjN2J3kJYM5/Grist-Quiz
Calendars and Cards
Learn all the tips and tricks to get the most out of calendar views in your documents. Cards pair nicely with calendars!
Deconstructing the Payroll Template
Rebuild our Payroll template to learn how to use formulas to look up hourly rates based on person, role, and date.