Defines values that are allowed in a worksheet column.


The Pebble Stream runtime will throw an error if this column has a value besides those listed. Users should use double quotes to indicate that the value is a string, otherwise, do not use double quotes. For blank, put blank. The following allowed-values directive allows only the values 2, 4, 6, and 8.


In Pebble Stream version 2, we have enhanced the allowed-values directive. Now users can stipulate multiple allowed-values directives in a single column. Additionally, the allowed-values directive now supports inequality descriptions. The following PebbleScript will allow numeric values greater than or equal to zero and less than 43, as well as the specific number 75.


The following PebbleScript will allow words that lexicographically occur before the word "yak" and after the word "antelope". It will also include the words "antelope", "aardvark", and "zebra".


Example 1

Example 2