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....
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.
- Holy cow this is amazing! Thank you. Im looking at your formulas now... not 1000% understanding them. Wanting to know more so next time I can do it myself.
What is the SMALL function doing. And Why is the primary one IFERROR? Thank you than kyou thank you!It's quite a complex formula. It is explained in the section "With INDEX" in Filter to extract matching values
The IFERROR replaces the #N/A value you'd get in rows for which there is no matching value.