Promoting your solutions built in Grist
Some users have asked us how they can sell solutions they have built in Grist. Often they’re an expert in a particular problem, have solved it in Grist, and want to help others solve it too.
Before building our own Grist marketplace, we want to experiment on an existing marketplace for templates and solutions services — Gumroad: https://gumroad.com/
If you’re interested in selling Grist solutions, we’d like to partner with you. Join our Discord and share your thoughts in the #sellers channel.
What’s New
Filtering reference and choice dropdown lists
When entering data into a reference or choice column you see a dropdown list of all available values to choose from. Sometimes the list can get long or confusing. You can now filter reference and choice columns’ dropdown lists by setting a condition. Learn how.
Use as table headers shortcut
Often when importing data from Excel to Grist, the first row contains what should be the column headers. Manually setting the correct column headers can be time consuming, but not anymore! Thank you to Camille Legeron (@CamilleLegeron) from the ANCT team who added a nifty shortcut to copy the values in a row to their respective columns’ labels. 
Create new team sites in self-hosted Grist
Thanks again to Camille Legeron who made it possible to create additional team sites in self-hosted Grist. To create a new site, select “Create new team site” from the user or site menu, specify the name and domain of the new site, and click “Create site.”
Admin console for self-hosters
The admin console for self-hosters now includes sandbox settings information and a checkbox to automatically check for Grist release updates. 
Networking improvements
Contributor Jonathan Perret (@jonathanperret) implemented a fallback mechanism for networks where WebSocket traffic is not allowed. If you or a colleague have had trouble using Grist behind a corporate network in the past, give it another shot!
Community highlights
- @v1adimirn0va built a custom widget that displays data on a timeline. If you’re in our Discord server, check it out here!
If you’re not in our Discord, join our server!
- Andreas Klöckner (@inducer on Github) built a tool to collect form responses and save them to existing records in a Grist document. Check it out here!
Working on something cool with Grist? Let us know by posting in the Showcase forum or our #grist-showcase Discord channel!
Learning Grist
Webinar: Reference and Choice Dropdown List Filtering
Filtering a reference or choice column’s dropdown list is very useful in a variety of cases. In May, we’ll show you how to write dropdown condition formulas for the most common scenarios.
Thursday May 16 at 3:00pm US Eastern Time.
AI Formula Assistant Best Practices
In April we covered Grist’s AI Formula Assistant which simplifies the hardest part of spreadsheets — formulas. In this webinar we share tips on how to get the most out of the assistant.
This was also Michael’s first time leading a webinar! Michael joined the Grist team as a Solutions Engineer in March.
Migrate from Spreadsheet.com
In case you missed it, in March we built a tool to help you migrate your Spreadsheet.com data into Grist, including attachments and relations, without the need to manually download and upload your files. Check it out here!
