I have a scenario in which a set of items are being manufactured (itemCount) for a given project (Name). Each item takes 17 working days to complete (which can be set in the text box above left).
Based on the start date value, a list of startDates and endDates (working days) is generated for each of the individual items.
I would then like to “explode” those lists into individual rows, as shown below.
I am able do generate the start date column with the formula below, however, the way I understand ForEach(), it must parse all values sequentially, preventing me from simply adding another statement for the endDate, such as this:
As for solutions, I’m open to an entirely different method if someone has a suggestion (although it should maintain the simplistic Name, itemCount and start date input fields. Thanks in advance.
Hi @Ryan_Hubbard1 - thanks for the response. I may have oversimplified my scenario a bit for ease of conveying the issue. In a real world scenario a typical project will be 75-150 items, hence my goal of adding only one line per project and exploding that versus the other way around.
Of course dates will need to be pushed (it’s manufacturing after all) so the plan would be a simple “offset by 𝑛 working days” button that applies the adjustment to the checked rows.
This tool will only be used temporarily while getting a comprehensive ERP system set up (and is simplifying—in part—the output of an incredibly complex spreadsheet solution).
@Nate_Eikelberg if that format is what works best for you then I believe this will get the job done. Assuming the start & end date pair are both in the Nth position you can use the Sequence function & a forEach to basically create a for(i=1, i=list length, i++) loop for your start/end date pairs and access the pairs using the Nth function.
Yes @Ryan_Hubbard1 , that seems to be what I need (and coincidently is the same solution I was working on concurrently – glad to see I was on the right track)! I was going going about it in a less straight forward manner though and creating an array for each line [module, startDate, endDate] and then attempting to iterate through using Sequence(1, itemCount) to indicate the array value and another Sequence(1,3) as to indicate the position. Your solution is much more straightforward. Thanks again for the time and energy put into it.
