» google sheet の記事

Example:
Added a new sheet and put the push down list on it
First, select the whole row
Data>Data validation
Change the Cell Range to C2:C
which means the formula will excluded the row 1(header)
Click on Criteria box
Choose the list sheet
Highlight the whole row which you want to able to select in the pull down menu, and changed to TaskConstantList!B2:B to skip the header
| HOME |

Smiley face

October 2020
S M T W T F S
 123
45678910
11121314151617
18192021222324
25262728293031