Commonly in your input form you might have validation on a drop-down field ensuring the user picks their selection from a pre-defined list.   In this example we have named the range ‘ListRegions’ and set it across the cell range B4:B7 to ensure it includes all 4 regions.     We’ve set the field up with Data Validation Read More …