March 2022 Newsletter#

Sprouts Program#

We’re launching a new program to help teams get up and running fast on Grist. If you know what you need, but need help building it, we’re here to help. Here’s how it works:

  • Eligibility. Anyone with a team site is eligible for the Sprouts program (even while on free trial).
  • Schedule a free 30-minute consultation call. Email success@getgrist.com and describe your use case. We’ll pair you with a Grist expert on our team and schedule a time to meet. On that call, we’ll estimate the scope of the work.
  • For quick projects. If we estimate your project can be completed in less than an hour, we’ll do it ourselves — for free! Many use cases fall into this category.
  • For larger projects. For projects longer than an hour, we’ll recommend a contractor who has been trained and vetted by Grist, and has quick access to our team.

Whether you choose to work with our contractor or with someone else, we’ll schedule one more 30-minute call to make sure everyone understands the project. Based on this, the contractor will estimate the work and quote a price.

Visit our website to submit an inquiry!

What’s New#

Conditional Formatting#

Conditional formatting is finally here! 🎊 In the creator panel in the column menu, under CELL STYLE you may now add conditional styles. Enter a formula and style the cell’s background and text color. You may add multiple conditional rules. Learn more.

Conditional Formatting

Improved Column Type Guessing#

When you import or copy and paste data, Grist is now much better at parsing data and guessing column types. Phew! That means less data cleaning when importing new data! 🎉

New API Method for Add or Update#

We added a new method to update an existing record, or, if it does not exist, add a new one. Learn more.

Grist-help Is Now Public!#

Our Help Center is maintained in GitHub. The repo is now public, so the community can help improve our documentation and tutorials.

Learning Grist#

Webinar: Custom Widgets#

Custom widgets have gotten easier. Learn how to configure custom widgets from the menu of premade widgets in the creator panel.

Thursday April 14th at 12:00pm US Eastern Time.

SIGN UP FOR MARCH’S WEBINAR

On March’s webinar, Anais walked through how to set up access rules on private and public documents.

WATCH MARCH’S RECORDING

Community Highlights#

  • Improve your Wordle stats with Grist! David Smedberg put Grist to the test by building a document that could track his Wordle stats across multiple devices and analyze his best guess words. He shared his document on our forum. His detailed blog post about his experience is worth a read. 🤩 Fantastic!

  • Apply Formula to Filtered/Visible Rows Only. Grist applies formulas to the whole column. What if you only want to transform filtered rows? Here’s a helpful workaround.

  • Toggle on/off if attachment present. Suppose you have an attachment column and would like to filter for rows that have attachments. Here’s how to toggle a switch to “on” if there is an attachment.

  • Showing images from URLs. Here’s how to configure a custom widget to preview images from URLs.

New Templates#

Event Sponsors + Attendees#

Track event registrations and ticket revenue, and reconcile sponsors and attendees.

Event Sponsors + Attendees

GO TO TEMPLATE

Public Giveaway#

Organize public giveaways on a first-come, first-serve basis. This template uses access rules to limit who can claim which gifts.

Public Giveaway

GO TO TEMPLATE

Project Management#

Keep track of tasks by department and project, and quickly flag tasks at risk

Project Management

GO TO TEMPLATE

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.