Rob Mulhern
New Member
Hi, Hope someone can help.
I need some lookups to some worksheets but need multiple lines added for each lookup.
Essentially I need a unique row created and looked up for every instance of a "Y" (in Green) per row under the blue deliverables area (E1:AT1) in the table on the "project deliverables matrix" worksheet. Below are the columns that all need populating per row.
See attached workbook.
Worksheet: "ScrumDo Story Import".
This needs lookups to be filled out for columns A, C, E, M, O, Q & R. There needs to be a row for each of the items marked Y (in Green) under the blue deliverables area (E1:AT1) in the table on the "project deliverables matrix" worksheet.
Column A "Iteration":
Assume maximum 2500 rows of data if limit needed.
Each row of data represents a card in Scrumdo. Each card is a deliverable. There needs to be a row for each of the items marked Y (in Green) under the blue deliverables area (E1:AT1) in the table on the "project deliverables matrix" worksheet.
Always goes into Backlog on first import.
Column B "Summary":
Summary is the formula for C2 in the ScrumDo Epic Import worksheet.
=CONCATENATE('Project Deliverables Matrix'!A3,CHAR(10),'Project Deliverables Matrix'!B3)
As above this needs to be repeated for each count of a "Y" under the blue deliverables area (E1:AT1) in the table on the "project deliverables matrix" worksheet.
Column E "Points":
Needs to lookup corresponding points entered into the yellow story points table (AV1:CL1) on Project Deliverables Matrix worksheet.
Column M "Tags":
=CONCATENATE('Project Deliverables Matrix'!A#," ",'Project Deliverables Matrix'!B#)
Where "#" represents the row that the deliverable relates to.
This will allow us to filter all of the cards via the epic and then link them to the relevant Epic Card once imported.
Column O "Lables":
Needs to look up column C in User Stories template so that the "user story template"reference can be imported to aid filtering
Column Q "Due Date":
Needs to lookup due date entered into 3rd table on Design Deliverables Matrix worksheet.
Column R "Created":
=Todays date for first import.
Thanks in advance for your help.
Cheers,
Rob
I need some lookups to some worksheets but need multiple lines added for each lookup.
Essentially I need a unique row created and looked up for every instance of a "Y" (in Green) per row under the blue deliverables area (E1:AT1) in the table on the "project deliverables matrix" worksheet. Below are the columns that all need populating per row.
See attached workbook.
Worksheet: "ScrumDo Story Import".
This needs lookups to be filled out for columns A, C, E, M, O, Q & R. There needs to be a row for each of the items marked Y (in Green) under the blue deliverables area (E1:AT1) in the table on the "project deliverables matrix" worksheet.
Column A "Iteration":
Assume maximum 2500 rows of data if limit needed.
Each row of data represents a card in Scrumdo. Each card is a deliverable. There needs to be a row for each of the items marked Y (in Green) under the blue deliverables area (E1:AT1) in the table on the "project deliverables matrix" worksheet.
Always goes into Backlog on first import.
Column B "Summary":
Summary is the formula for C2 in the ScrumDo Epic Import worksheet.
=CONCATENATE('Project Deliverables Matrix'!A3,CHAR(10),'Project Deliverables Matrix'!B3)
As above this needs to be repeated for each count of a "Y" under the blue deliverables area (E1:AT1) in the table on the "project deliverables matrix" worksheet.
Column E "Points":
Needs to lookup corresponding points entered into the yellow story points table (AV1:CL1) on Project Deliverables Matrix worksheet.
Column M "Tags":
=CONCATENATE('Project Deliverables Matrix'!A#," ",'Project Deliverables Matrix'!B#)
Where "#" represents the row that the deliverable relates to.
This will allow us to filter all of the cards via the epic and then link them to the relevant Epic Card once imported.
Column O "Lables":
Needs to look up column C in User Stories template so that the "user story template"reference can be imported to aid filtering
Column Q "Due Date":
Needs to lookup due date entered into 3rd table on Design Deliverables Matrix worksheet.
Column R "Created":
=Todays date for first import.
Thanks in advance for your help.
Cheers,
Rob