July 2022 Newsletter#
Welcome to our monthly newsletter of updates and tips for Grist users.
|
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.
Learning Grist#
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.
Community Highlights#
-
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.
Sprouts Program#
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.
New Templates#
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! 🙏
We are here to support you#
Have questions, feedback, or need help? Search our Help Center, watch video tutorials, share ideas in our Community, or contact us at support@getgrist.com.