Learn how Grist contains the spreadsheet sprawl. Similar to our previous Grist/Excel webinar, we’ll see how Grist is designed to avoid many of the very familiar problems associated with spreadsheet workflows, such as merging and normalizing.
Timestamps
00:34 User question: can you leave comments in Grist? 01:46 User question: form publishing permissions? user access to document permissions? 04:08 User question: how to calculate sums? 07:47 Webinar introduction: what are we building and why? 12:46 Creating a new document and planning your solution 17:20 Deciding which data tables you need 18:35 Importing data from Excel into a new table, and formatting columns 21:02 Adding new columns 21:44 Adding new tables 23:44 Importing data into an existing table 25:25 Applying a formula to data during import 26:46 Relating data across tables with reference columns 30:35 Linking related data in two widgets 31:46 Understanding the difference between VIEWS of data and DATA TABLES 34:10 Formulas! Understanding formulas in Grist 35:35 Tips when using the AI Formula Assistant to write Python formulas 38:48 Using lookups and sum shortcuts in the “Add Column” menu 42:39 From the top! Adding another use case to this solution by reviewing what we’ve learned so far 46:55 Access rules! Reviewing the default rules 48:33 Creating user attributes in Access Rules 51:15 Setting default rules for new table rules 52:38 Creating row-level access rules with user attributes (and some troubleshooting!) 56:49 Understanding reference columns, their values, and how to include them in access rules 01:01:02 Previewing access rules as other team members 01:03:00 Conditional formatting
