I have a template with a column “task dependency”, it set dependency on, after I launch to tracker table, the dependency still point to the template table, how can I change/modify the dependency to tracker table?
I try to use the code below to point the dependency to a correct row, but it show in the task dependency column.
WithName(
[Task Tracker].Filter(
[Unique ID] = CurrentValue.[Dependency ID] And
[Related Launch] = thisRow
),
MatchingRow,
ModifyRows(
CurrentValue,
[Task Tracker].[Task Dependency],
MatchingRow
)
)