Spreadsheet: 880012d1727617824-formula-for-2-dependent-lists-that-depend-on-the-choice-made-in-one-and-the-same-column-kristinecopy
Sheet: Data-invoer

[NAME]:
 |  |  |  |  |  | PROJECTEN |  |  |  | KERNTAKEN |  |  |  | EXTRA_TASKS |  | * FILL IN ON PLANNER
[NAME] werknemer/teamlid |  |  |  | Level 0: type of projects& tasks |  | Level 1: name project | Level 2: tasks (5 categories) | Level 3: subtasks |  | Level 1: name project | Level 2: tasks (5 categories) | Level 3: subtasks |  | Level 1: name external teams | Level 2: example tasks | Level 3:optional: description
TOEGEWEZEN AAN |  | NAAM VAN ORGANISATIE |  | TYPE |  | Project_A | Tasks_Project_A | Subtasks_Project_A |  | Kerntaken_team | Tasks_Team | SUBTAKEN |  | Externe_activiteiten | External_tasks | OMSCHRIJVING
Kristine |  | Help |  | Project_A |  | FictionalName1 | Organisation_communication | FictionalTask1 |  | Teamgeneral | Administration_something | FictionalTask1 |  | abc | FictionalName1 | FictionalDescripton1
Colleague |  | SOS |  | Kerntaken_team |  | [NAME] 2 |  | FictionalTask2 |  | Specific1 |  | FictionalTask2 |  | def | [NAME] 2 | FictionalDescripton2
 |  | Company |  | Externe_activiteiten |  | Alonglist |  | FictionalTask3 |  | Specific2 |  | FictionalTask3 |  | ghi | FictionalName3 | FictionalDescripton3
 |  | Yetanothercompany |  |  |  | Offartoomany |  | FictionalTask4 |  |  |  | FictionalTask4 |  | klm | FictionalName4 | FictionalDescripton4
 |  |  |  |  |  | Projects |  | FictionalTask5 |  |  |  | Projectfiches5 |  | nop | FictionalName5 | FictionalDescripton5
 |  |  |  |  |  | FictionalName3 |  | FictionalTask6 |  |  |  | FictionalTask6 |  | qrs | FictionalName6 | FictionalDescripton6
 |  |  |  |  |  | FictionalName4 |  | FictionalTask7
 |  |  |  |  |  | FictionalName5 |  | FictionalTask8 |  |  | Communication | abc
 |  |  |  |  |  | FictionalName6 |  | FictionalTask9 |  |  |  | def
 |  |  |  |  |  | Moreprojects |  | FictionalTask10 |  |  |  | ghi
 |  |  |  |  |  | EvenMoreprojects |  |  |  |  |  | jkl
 |  |  |  |  |  |  | Video_content | FictionalTask1 |  |  |  | mno
 |  |  |  |  |  |  |  | FictionalTask2 |  |  |  | pqr
 |  |  |  |  |  |  |  | FictionalTask3 |  |  |  | [NAME]
 |  |  |  |  |  |  |  | FictionalTask4
 |  |  |  |  |  |  |  | FictionalTask5 |  |  | Platforms | Vw
 |  |  |  |  |  |  |  | FictionalTask6 |  |  |  | xy
 |  |  |  |  |  |  |  | FictionalTask7 |  |  |  | zzz
 |  |  |  |  |  |  |  | FictionalTask8 |  |  |  | Teams
 |  |  |  |  |  |  |  | FictionalTask9
 |  |  |  |  |  |  |  | FictionalTask10 |  |  | Quality | 123
 |  |  |  |  |  |  |  |  |  |  |  | 456
 |  |  |  |  |  |  | E_content | FictionalTask1 |  |  |  | Templates, visuals, demo's
 |  |  |  |  |  |  |  | FictionalTask2 |  |  |  | Marketing/Branding
 |  |  |  |  |  |  |  | FictionalTask3 |  |  |  | Testing/feedback
 |  |  |  |  |  |  |  | FictionalTask4 |  |  |  | 789
 |  |  |  |  |  |  |  | FictionalTask5 |  |  |  | 101112
 |  |  |  |  |  |  |  | FictionalTask6 |  |  |  | 131415
 |  |  |  |  |  |  |  | FictionalTask7
 |  |  |  |  |  |  |  |  |  |  | Educationorsomething | FictionalTask1
 |  |  |  |  |  |  | Review_content | Review1 |  |  |  | FictionalTask2
 |  |  |  |  |  |  |  | Review2 |  |  |  | FictionalTask3
 |  |  |  |  |  |  |  | Finalising |  |  |  | FictionalTask4
 |  |  |  |  |  |  |  |  |  |  |  | FictionalTask5
 |  |  |  |  |  |  | Publication_content | FictionalTask1 |  |  |  | FictionalTask6
 |  |  |  |  |  |  |  | FictionalTask2
 |  |  |  |  |  |  |  | FictionalTask3