» 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

April 2020
S M T W T F S
« Mar    
 1234
567891011
12131415161718
19202122232425
2627282930