Google Spreadsheet Post #1474
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-05-2014
question by curtisblackwell (http://productforums.google.com/forum/?zx=tzsloqibo1wn#!mydiscussions/docs/3jkaHv6R-mM)
Is there a way to have multiple data validation rules or to mimic "List from a range?"
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-05-2014
question by curtisblackwell (http://productforums.google.com/forum/?zx=tzsloqibo1wn#!mydiscussions/docs/3jkaHv6R-mM)
Is there a way to have multiple data validation rules or to mimic "List from a range?"
I'm currently using the "List from a range" option to validate a column. However, there's one valid string that isn't in that range, and adding it to that range would disrupt the flow.
Is there a way to setup multiple validation rules? If not, is there a way to mimic "List from a range" in "Custom formula is?"
------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment