June 2022 Newsletter#
Hope you had a fun and colorful Pride month! We did. Rainbow spreadsheet! 🏳🌈
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 () 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.
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.
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.
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.
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.
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! 🙏