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. 

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. 

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 

Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google account