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
Chat with Your Data
See how Grist’s new AI Assistant helps you analyze data, write formulas, and clean fields — using natural language.
Creating Custom Invoices
Create and customize invoices in Grist—set up, brand, and generate professional, printable invoices with the Invoice custom widget.
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.