[July 11, 2024] We have updated the rollout information for this feature. See the Rollout section below for more details.
What’s changing
In March, we introduced the ability to insert preset dropdown chips that are configured for common use cases like priority or review statuses in Google Sheets. Today, we’re adding a new feature that helps you quickly convert ranges of data into dropdown chips in bulk.
If you have a column of data that includes a variety of data values (e.g., different project statuses like on track, paused, completed), Sheets will show a “Convert to dropdown chips” suggestion when you click into your data range. By hovering over that indicator, you can preview the suggestion and then convert to dropdown chips in one click.
Getting started
- Admins: There is no admin control for this feature.
- End users:
- To insert dropdown chips on your own, type “@” followed by “dropdown”.
To turn off this feature, go to Tools > Suggestion controls > (deselect) Enable dropdown chip suggestions. - Visit the Help Center to learn more about inserting smart chips in your Google Sheets.
Rollout pace
- Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on May 7, 2024, with expected completion by August 8, 2024
- Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on August 22, 2024
Availability
- Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts