Google Sheets Tutorial – How to Enable Multiple Selection Data Validation Using Apps Script

1

Love the How to Enable Multiple Selection Data Validation Using Apps Script Google Sheets tutorial. It works great!

Since the “validated” cell now has multiple values, it no longer “matches” the defined (single-value) validation rule, so hovering over the cell results in the ol’

Invalid:
Input must fall within specified range

message, accompanied by the dreaded “red triangle”

image

Is there any way to suppress the pop-up & red triangle as part of the Apps Script?

Thanks!

2

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.