Google Sheets customize data validation hover help text
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?
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:
where when the unallowed option is forced through the system:
the custom validation help text is meant to be shown in the message box:
and not as a hover note assigned to the cell with invalid input:
