Forum Discussion
dnrk5432
Jan 22, 2024Copper Contributor
Creating a monthy schedule that autopopulates from a task list
I have a list of events, with tasks under each one and due dates.
I want to create a formula that searches all the events, and puts each task in the corresponding month it needs to be completed. The end goal is I can see each month, the task to do, the deadline, and which event it goes to.
Also I have Excel 2019, so I do not have some of the newer functions.
Attached is an example file. I have manually entered one of the events, but I want a function that could do it for me. In my real spreadsheet, I have a ton of tasks... very overwhelming!
Help is appreciated. Thanks 🙂