I created a list that contains the title of an assignment and its current status: "Completed" or "Pending Scheduling". I also have a second list that I want to display all items that are "Pending Scheduling". This second list updates every time an item is added to the first.
I think that I need to loop through all the items in the "Title" column of the first list to accomplish this, and every time a row's status has a "Pending Scheduling", the corresponding title needs to be added into the second list. Also, if an item's status in the first list is changed to "Completed", that item should disappear from the second.
How do I do this?