November 2021 Newsletter#
Welcome to our monthly newsletter of updates and tips for Grist users.
|
What’s New#
Import Column Mapping#
When importing additional data to an existing table in Grist, you can now map columns in your file to columns in the Grist table. Learn more.
Filter on Hidden Columns#
It is now possible to filter tables based on data in hidden columns. 👻
More Sorting Options#
There are now more sorting options available, including natural sort. Learn more about additional sorting options.
Note that Choice columns have a unique sorting option based on choice position in the choice configuration.
Donut Chart#
Grist now supports donut charts!
Python 3.9#
Python 3.9 is the new default for new documents. Compared to previous default (2.7) it has some useful packages such as mathematical statistics functions. Learn more about supported Python versions.
#1 Product of the Day on Product Hunt!#
Grist achieved Product of the Day on Product Hunt! 🎉🚀🐱🚀 Thank you for showing your support! Many Grist creators took time out of their day to leave kind reviews and words of encouragement. Thank you! 🙏
Learning Grist#
Build with Grist Webinar#
Join Grist experts on a live webinar to learn Grist best practices.
Wednesday December 15th at 3:00pm US Eastern Time (New York).
During November’s webinar, Grist VP of Product Anais Concepcion discussed the difference between typical formulas and trigger formulas, and when to use which. She also shared some of her favorite formulas and dove deep into how to use reference columns in lookup formulas.
Video: Finding Duplicate Values with a Formula#
Formulas are a great way to find and flag duplicate values in a column. This video breaks down a formula that finds duplicates to deepen your understanding of formulas and Grist.
Community Highlights#
-
Split text string into a list. If you import a long string of text, such as keywords separated by commas, it would be useful to break that string into a list of values that may be filtered and grouped in a Choice List column. Learn how.
-
Identifying values that are not in another table. In the video above, the formula finds duplicates (or unique values) in the same column. Learn how to compare values across tables.
New Templates#
Recruiting#
Collaboratively track job applicants, and attach resume and interview notes.
Portfolio Performance#
Track your portfolio value and performance, including closed and open P&L.
Event Speakers#
Track speakers booked for events, and flag events that are not yet fully booked.
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! 🙏
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.