What’s changing
In 2022, we announced the ability to create dropdown chips in Google Sheets. This custom formatting smart canvas feature enables you to easily indicate statuses or various project milestones within your spreadsheet.
Today, we’re building upon this by introducing preset dropdowns. Instead of manually creating values for your dropdowns, you can insert preset dropdown chips that are configured for common use cases like priority or review statuses. After inserting a preset dropdown, you can use the data validation sidebar to easily adjust the options or add styles.
Getting started
- Admins: There is no admin control for this feature.
- End users: You can insert a dropdown chip by typing “@” followed by “dropdown”. Visit the Help Center to learn more about inserting smart chips in your Google Sheets.
Rollout pace
- Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on March 5, 2024
- Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on March 19, 2024
Availability
- Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google account