During November’s webinar, Anais discussed the difference between typical formulas and trigger formulas, and when to use which. She also shared some of her favorite formulas and dove deep into how to use reference columns in lookup formulas.
Timestamps
00:31 DnD Encounter template 00:50 Embedding iframes in custom widgets 02:55 The difference between trigger formulas and regular formulas 04:15 No code hiring template walkthrough 05:45 Auto-adding a date with trigger formulas 07:35 Auto-adding user information with trigger formulas 08:29 Data cleaning with trigger formulas 11:07 Understanding .format() formula 13:08 Reverse reference lookup – finding all the records related to a specific record 18:24 Looking up fields with a lookupRecords() function 18:34 Combining AVERAGE() and lookupRecords() 18:53 How to use IFERROR() 19:58 Formula challenge – funding duplicates 21:15 Changing the currency on the invoice template’s custom widget 23:24 Best way to learn Grist? 24:39 Comparing Grist and Airtable 28:40 Grist won Product of the Day on Product Hunt! Thank you!!
Recent Webinars
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.
Migrating data from Excel to Grist: Team Expenses
Improve upon Excel-based expense tracking with Grist. Learn to import data, set up dashboards and manage access control.
