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....
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.
