| A | B | C | D | E | |
|---|---|---|---|---|---|
1 | URL for this row's links (can be hidden) | Normal dropdown | Special dropdown | Special dropdown, multi-select | |
2 | http://youtube.com | | three | | |
3 | http://agingbiotech.info/ | Option 2 | | | |
4 | http://google.com/ | Option 1 | three | three, one | |
5 | http://fightaging.org/ | | | | |
6 | http://dogs.com | Option 2 | | three, one, two | |
7 | |||||
8 | |||||
9 | |||||
10 | |||||
11 | |||||
12 | Special dropdowns are indicated by setting help text in Data Vaildation / Advanced options to avoid hardcoding sheet name/column/row references of dropdowns in script. | ||||
13 | |||||
14 | |||||
15 | |||||
16 | |||||
17 | |||||
18 | |||||
19 | |||||
20 | |||||
21 | |||||
22 | Note that this help text sometimes resets to default when editing dropdowns, I havent determined the exact circumstances where that happens, but if it does just reenter #CREATELINK | ||||
23 |