Google Sheets customize data validation hover help text

user_10864569 0
Viewed 62

I'm working with a Google Sheet and running into issues with hover text for data validations. Here is a demo spreadsheet which shows what I am doing.

Essentially, I'm using data validations as a dropdown menu from a range. But, I only want want to show warnings on invalid data. I customized the help text of my warnings, currently set to This is a custom help text message. You can see this in the Data > Data Validations menu. However, when you hover over any of the invalid inputs, all you get is Invalid: Input must fall within specified range. I want my custom text to show in the red hover section. Is there any way around this? Or is it just a Google Sheets glitch?

This may be a related question.

google-sheets validation
1 Answers

the current state of google sheets data validation settings may sound like misleading, but the functional inquiry of custom validation help text is directly bound to the Reject input option only:

enter image description here

where when the unallowed option is forced through the system:

enter image description here

the custom validation help text is meant to be shown in the message box:

enter image description here

and not as a hover note assigned to the cell with invalid input:

enter image description here

user_56326290
Related