In this webinar, we take a common spreadsheet use case, expense tracking, and compare workflows in Grist vs Excel.

Timestamps

00:00 Fun round – Building memes in Grist!
01:50 Lightning round – questions submitted during sign-up
06:30 Expense Tracking in Excel — common workflows and drawbacks
10:02 Importing expenses to Grist and formatting columns (+ strftime() Python method)
14:21 Creating summary tables (aka pivot tables) and linking widgets to drill into data
17:45 Creating charts that aggregate and drill into data
19:25 Pages v. views of data v. data tables
20:38 Importing additional expenses into the Grist document
24:15 Renaming tables, identifying summary tables and their group by columns at a glance
25:18 Quick tip: Data cleaning with trigger formulas (title case to text strings)
26:48 Working in a team with granular access rules – overview of default rules and user access
29:30 Row level access rules based on users’ login emails
33:45 Column-level access rules: hiding columns v. restricting columns, key difference!
35:15 Restricting pages and summary tables
36:16 Reviewing the simplified workflow!
37:50 Exporting filtered data as a CSV and working on copies
39:20 Q&A

Links

• Invoice template example: https://templates.getgrist.com/9NH6D58FmxwP/Invoicing
• Creating Productive Layouts (w/ Widgets): https://www.youtube.com/watch?v=QZnKhtqJR0c&t=0s
• Access Rules Webinar: https://www.youtube.com/watch?v=chDCNUHqi6w&t=0s
• Sprouts: https://www.getgrist.com/sprouts-program/
• Community Forum: https://community.getgrist.com/