We use a checklist with 340 lines. We currently create a new sheet for each project. We would like to create a kanban that links these projects utilizing the highest level of the hierarchy as the lanes (5 lanes) and the next level as dropdowns in the cards (9 at the most.) The third level is where the actual tasks are but for the purpose of this linked kanban, we would not need to deal with that level. It does not seem to make sense to copy and paste the checklist into a single file for each project but that is what gives us the functionality that we need and it seems unwieldy to try to manage all those cell links. Is there another solution that has not occurred to this newbie.
