» 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

March 2024
S M T W T F S
 12
3456789
10111213141516
17181920212223
24252627282930
31