In September we’ll rebuild our Payroll Template. This template uses formulas to look up hourly rates based on person, role, and date. You’ll also learn how to build dynamic summary dashboards that summarize data by categories and let you drill into the records in those categories.
Timestamps
02:07 Sneak Peek: Calendar 04:06 Introduction to webinar and template 08:40 Creating a new document and meta table to plan ahead 11:14 Importing from Google Drive 12:20 Concatenating text with a formula 14:15 Using reference columns to relate data in different tables 15:50 Choice columns – setting and formatting choice values 17:30 Quick Tip: Updating default currency and time zone in Document Settings 20:55 Formula Breakdown (Per Hour): how to pull current rate for a specific person and role 32:20 Using a formula to create Pay Periods 33:59 Building dynamic dashboards with linked widgets and charts 37:53 Quick way to hide multiple columns at a time 38:05 Editing card layout 39:00 Applying multiple sorts to a table
Recent Webinars
Access Rules for Distributed Organizations
Learn to secure and manage data across multiple locations, control access at every level, and keep sensitive information in the right hands.
Integrating an open-source solution into a national digital strategy
Learn how governments build a national digital strategy around spreadsheets that’s both sustainable and truly sovereign.
Grist 101: A New User’s Guide
Join us for an introductory webinar to help new users navigate the basics of Grist. Learn key features and best practices. Perfect for beginners.
