flowchart
1 Topic
Data validation lists - flow chart?
Hello, I'm a school leader and I'm trying to create an Excel spreadsheet to track Teaching & Learning action steps that I give to teachers. I understand how to create a drop down list but what I'm trying to do is essentially create a list within a list, like a flow chart. For example: I'm creating a Maths specific tracker at the moment that has 3 dimensions of depth and specific focuses for each dimension. So if I select the dimension of depth as "Language and Communication" then I want a list of Language & Communication focuses to appear to be selected. But if I select the dimension of depth as "Conceptual Understanding" then I want a list of Conceptual Understanding focuses to appear instead. From there I want to be able to type in the action step as normal. I've attached a very basic excel of what I'm looking for. Ideally I'd like to have just one document with a different page for each teacher rather than loads of separate spreadsheets. Is there a way that I can do this?Solved11KViews0likes16Comments