Show a warning for invalid data in Google Sheets
Create a dropdown in B2:B4 with exactly Draft, Ready, and Published. In Advanced options, set invalid data to Show a warning rather than Reject the input.
Verified by JosephineAbout 60 secondsCreate a dropdown in B2:B4 with exactly Draft, Ready, and Published. In Advanced options, set invalid data to Show a warning rather than Reject the input.
Step-by-step
Select the targetCreate a dropdown in B2:B4 with exactly Draft, Ready, and Published.
Apply the changeIn Advanced options, set invalid data to Show a warning rather than Reject the input.
Shortcut or faster method
Use the menu path shown in the video and keep the target range selected until the change is applied.
Expected result
B2:B4 has the exact three-option dropdown and invalid entries show a warning.
Common mistake
Applying the change to more rows, columns, or cells than the task specifies.
Troubleshooting
Re-select B2:B4 and repeat the final action. B2:B4 has the exact three-option dropdown and invalid entries show a warning.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Request | Status |
| Homepage copy | |
| Pricing review | |
| Launch email |
Video transcript
- Open the prepared Practice spreadsheet.
- Select the target. Create a dropdown in B2:B4 with exactly Draft, Ready, and Published.
- Apply the change. In Advanced options, set invalid data to Show a warning rather than Reject the input.
- B2:B4 has the exact three-option dropdown and invalid entries show a warning.