Hi,
I am using the below formula to add Tasks for a Project from a Tasks Template.
RunActions(
[Task Templates]
.Filter(
[Project Template Name] =
thisRow.[Project Template Name]
)
.ForEach(
RunActions(
AddRow(
[All Tasks of All Projects],
[All Tasks of All Projects].[Project Name],
thisRow.[Project Name],
[All Tasks of All Projects].[Task Name],
CurrentValue.[Task Name],[All Tasks of All Projects].Status,CurrentValue.Status,[All Tasks of All Projects].Dependency,CurrentValue.Dependency
)
)
)
)
Link is https://coda.io/d/Project-Details-Doc_djHwf_Ee-xq/DB_suUV8#_lu5-V
However, the tasks in the Dependency field are not getting resolved to the Tasks in the [All Tasks of All Projects] table as you can see below. Due to this, I am unable to run formulas on this Dependency field. Please help with a resolution.