June 2022 Newsletter#
Welcome to our monthly newsletter of updates and tips for Grist users.
|
-
Range Filtering
-
Happy Pride!
Check out our rainbow spreadsheet! 🌈
-
Webinar: Structuring Relational Data
Best tips on how to structure data in Grist.
-
2 New Templates
Expense tracking and meal planning.
-
PEEK(a-boo)
Special new function to resolve circular references in trigger formulas.
Happy Pride!#
Hope you had a fun and colorful Pride month! We did. Rainbow spreadsheet! 🏳🌈
What’s New#
Range Filtering#
It is now possible to filter Numeric and Date columns by a range! Keep an eye out for more improvements to filtering in the near future.
PEEK()#
PEEK () evaluates an expression without creating dependencies or requiring that referenced values are up to date, and uses whatever value it finds in a cell. This is useful for preventing circular reference errors, particularly in trigger formulas. Learn more.
Here’s an example of PEEK() in action. Note that in the trigger formula column, the two formulas can reference each other without creating a circular error.
Learning Grist#
Webinar: Structuring Data in Grist#
Before you can build productive layouts, you have to think through how to structure your data. In July, we’ll share some best practices and highlight the differences in how data is structured in spreadsheets v. Grist.
Thursday July 21st at 3:00pm US Eastern Time.
In June Anais demonstrated how Grist can simplify data workflows, such as expense tracking, when compared to traditional spreadsheets.
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.
Quick Tips#
-
All formula columns in summary tables can be series in charts based on that summary table. For example, in the General Ledger template, the Profit columns in the summary tables are used in the charts.
-
There are additional sort options in the creator panel’s sort menu under the three dots icon.
-
In case you missed it. The Grist video player is a custom widget that plays a video from a URL, similar to how the image viewer displays an image from a url.
Community Highlights#
-
Conditional trigger formulas. Use a trigger formula to conditionally autofill data in some cases, but not others.
-
Setting default value for reference column. Use trigger formulas to set default reference values.
New Templates#
Expense Tracking for Teams#
Manage all employee expenses in one spreadsheet! No more wrangling dozens of employees’ expenses into a master list. With access rules, employees can log into Grist, view and update only their expenses, and Grist summary tables take care of the rest.
Grocery List + Meal Planner#
Create recipes, build weekly menus and make a grocery list in one place!
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.