Hi! I know it’s not the best but it’s the only way I can think of doing it. Here’s the page in question (you will need to request access to the page since it’s a page that is not visible to anything outside the org)
I have a table called [Sprints per project]. What I want to do is iterate through the [All project List] to find all “Closed” projects, compare it to the [Completed Projects and their sprints] table, and if the project is closed, pull all the details from the [Completed Projects and their sprints] and copy them [Sprints per project].
In the end, I would like to see project 1 and project 3 in the [Completed Projects and their sprints] table as well as the related team, what sprints they were a part of, and what allocation they are assigned to. I tried it in a personal doc but was unable to find out if I could avoid the nested foreach. Please send help, thanks!