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
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.
Two-Way References
Two-way references are here! Learn how to link data in both directions, opening up new and powerful ways to leverage relational data.
✨New Feature Showcase
Catch up on the latest Grist features that you may have missed, including markdown in cells, cumulative functions, the formula timer, and record cards.