Forum Discussion
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 🙂
13 Replies
If you cannot attach a workbook, upload it to a cloud store such as Google Drive, OneDrive or Dropbox, obtain a link to the uploaded and shared file and paste that link into a reply.
Thanks!! I didnt realize it didnt attatch HansVogelaar
https://vastate365-my.sharepoint.com/:x:/g/personal/drimm-kaufman_vsu_edu/EcMPLtTfibhDv-5-BFIuYgcBgOR0ZL34QdmFDfZfKi7F2g?e=jGAhYB
I changed the layout slightly to make it easier to create formulas.
