July 2022 Newsletter#
Formula Cheat Sheet#
New to Grist formulas and Python? Here’s a formula cheat sheet with the most commonly used functions and plenty of examples.
If you want extra formula help, we also have an in depth article focused on references and lookups with more examples.
Summary Tables in Raw Data#
Summary tables are now listed in raw data, making it easier to see at a glance what summary tables exist anywhere in the document, and examine any of them. You can easily identify summary tables by the sigma icon.
Note also the friendlier names for summary tables, like
Sales_summary. Anyone who has ever noticed
GristSummary_5_Sales will know what we are talking about.
Webinar: Relational Data and Reference Columns#
August’s webinar will focus on how to relate data in Grist using reference columns, how to use related data in dynamic dashboards, and how to perform lookups.
Thursday August 18th at 3:00pm US Eastern Time.
How to structure your data#
In July, Anais demonstrated how Grist can simplify data workflows, such as expense tracking, when compared to traditional spreadsheets.
Summarizing data with a pie chart. Learn how to create pie charts in Grist.
Find and highlight duplicates with conditional formatting. Learn how to set conditional styles based on a formula that returns whether or not a value is a duplicate.
Get up and running fast with expert help. If you know what you need, but need help building it, the Sprouts program may be for you.
Sales Commission Dashboard#
Sales and accounting teams can use this template to track sales and commission. Sales reps only see their individual sales, and the overall leaderboard. Management can see everything.
User Feedback Responses#
Improve your product based on customer feedback! Analyze and evaluate your user survey responses.
Net Promoter Score Results#
Keep your finger on the pulse of your customers’ satisfaction. Analyze and drill into your NPS survey responses.
Help spread the word?#
If you’re interested in helping Grist grow, consider leaving a review on product review sites. Here’s short list where your review could make a big impact. Thank you! 🙏