Spreadsheet: 117584d1312897094-advanced-dropdown-list-test
Sheet: U1 - U4

 | Week 1
 | Monday | Traning | Pass | Intensity | Zone | Kcal | Time | Min / Km | Distance / Km |  |  |  |  | Mockup Dropdown List - Swimming
 |  |  |  |  |  |  |  |  |  |  | Dropdown
 | Cardio | Swimming | Pass 1 | Intensiv |  |  | 1:00:00 |  | 2.4 |  | Sum | Total | Total | Total | Total | Total | Total
 |  | Distance | Sum | Racepace |  |  | 1:00:00 |  | 15 |  | Pass 1 | Intensity | Zone | Kcal | Time | Min / km | Distance
 |  | Interval | Sum | [NAME] |  |  | 0:19:00 |  | 6 |  | Pass 2 | Intensity | Zone | Kcal | Time | Min / km | Distance
 |  | Hometrainer | Pass 2 | [NAME] |  |  | 1:00:00 |  | 35 |  | Pass 3 | Intensity | Zone | Kcal | Time | Min / km | Distance
 |  | Cycling | Sum | Intensiv |  |  | 1:20:00 |  | 45 |  | Pass 4 | Intensity | Zone | Kcal | Time | Min / km | Distance
 | Total
 |  |  |  |  |  |  |  |  |  |  | From the row "Pass" (D4) one should be able to choose Pass 1 or Pass 10 (if 10 is needed) from a list and fill the empty cells.
 | Tirsdag | Træningspas |  | Intensitet | Zone | Kcal | [NAME] | Min / Km | Distance / Km
 | Cardio | Svømning |  | Intensiv |  |  | 1:05:00 |  | 16
 |  | Distance |  | Moderat |  |  | 0:30:00 |  | 10
 |  | Interval |  | [NAME] |  |  | 0:00:00 |  | 0
 |  | Hometrainer |  | [NAME] |  |  | 0:00:00 |  | 0
 |  | Cykling |  | Intensiv |  |  | 0:00:00 |  | 0
 | Total
 | Onsdag | Træningspas |  | Intensitet | Zone | Kcal | [NAME] | Min / Km | Distance / Km
 | Cardio | Svømning |  | Intensiv |  |  | 0:35:00 |  | 10
 |  | Distance |  | Vælg |  |  | 0:00:00 |  | 0
 |  | Interval |  | [NAME] |  |  | 0:00:00 |  | 0
 |  | Hometrainer |  | [NAME] |  |  | 0:00:00 |  | 0
 |  | Cykling |  | Intensiv |  |  | 0:00:00 |  | 0
 | Total
 | Torsdag | Træningspas |  | Intensitet | Zone | Kcal | [NAME] | Min / Km | Distance / Km
 | Cardio | Svømning |  | Intensiv |  |  | 0:25:00 |  | 5
 |  | Distance |  | Racepace |  |  | 0:35:39 |  | 10
 |  | Interval |  | [NAME] |  |  | 0:30:00 |  | 8
 |  | Hometrainer |  | [NAME] |  |  | 0:00:00 |  | 0
 |  | Cykling |  | Intensiv |  |  | 0:00:00 |  | 0
 | Total
 | Fredag | Træningspas |  | Intensitet | Zone | Kcal | [NAME] | Min / Km | Distance / Km
 | Cardio | Svømning |  | Intensiv |  |  | 0:45:00 |  | 10
 |  | Distance |  | Vælg |  |  | 0:00:00 |  | 0
 |  | Interval |  | [NAME] |  |  | 0:00:00 |  | 0
 |  | Hometrainer |  | [NAME] |  |  | 0:00:00 |  | 0
 |  | Cykling |  | Intensiv |  |  | 0:00:00 |  | 0
 | Total
 | Lørdag | Træningspas |  | Intensitet | Zone | Kcal | [NAME] | Min / Km | Distance / Km
 | Cardio | Svømning |  | Intensiv |  |  | 0:39:00 |  | 10
 |  | Distance |  | Vælg |  |  | 0:00:00 |  | 0
 |  | Interval |  | [NAME] |  |  | 0:00:00 |  | 0
 |  | Hometrainer |  | [NAME] |  |  | 0:00:00 |  | 0
 |  | Cykling |  | Intensiv |  |  | 0:00:00 |  | 0
 | Total
 | Søndag | Træningspas |  | Intensitet | Zone | Kcal | [NAME] | Min / Km | Distance / Km
 | Cardio | Svømning |  | Intensiv |  |  | 0:22:00 |  | 5
 |  | Distance |  | Vælg |  |  | 0:00:00 |  | 0
 |  | Interval |  | [NAME] |  |  | 0:00:00 |  | 0
 |  | Hometrainer |  | [NAME] |  |  | 0:00:00 |  | 0
 |  | Cykling |  | Intensiv |  |  | 0:00:00 |  | 0
 | Total