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
Links:
- Community Forum: https://community.getgrist.com/
- Discord Server: https://discord.gg/MYKpYQ3fbP
- Summary tables guide: Summary Tables Guide - Grist Help Center
- References and lookups: References and Lookups - Grist Help Center