Forum Discussion

AlanRasmussen's avatar
AlanRasmussen
Qrew Member
3 years ago

Formula Help | Field for Deliverable Start and Finish from Associated Tasks

Hello - I was hoping for some direction on how best to create a field for deliverable planned start and deliverable planned finish that would calculate based off the minimum start of associated tasks and maximum finish of associated tasks.  I'd like my result to look like the below:
Project Name Deliverable Name Task Name Planned Start Duration Planned Finish Deliverable Planned Start Deliverable Planned Finish
Project 1 Deliverable 1 Task A 04/26/22 3 04/28/22 04/26/22 (?) 05/04/22 (?)
Project 1 Deliverable 1 Task B 04/29/22 5 05/03/22 04/26/22 (?) 05/04/22 (?)
Project 1 Deliverable 1 Task C 05/04/22 1 05/04/22 04/26/22 (?) 05/04/22 (?)
I cannot seem to create a query that would list out 4/26/22 as the deliverable start and 5/4/22 as the deliverable finish.

This is in a task table called DBID_NEW_TASKS  
Project Name = field 49
Deliverable Name = field 7
Planned Start = field 20
Planned Finish = field 22
Is Start Milestone = field 23
Is Finish Milestone = field 64

What I tried and failed with for Deliverable Planned Start:

SumValues(GetRecord(ToDate("{7.EX.'"&[Deliverable Name]&"'}AND{49.EX.'"&[Project Name]&"'} AND{23.EX.'TRUE'}"), [_DBID_NEW_TASKS]), 20)

Any help or suggestions on how best I get this working? Thank you in advance.



------------------------------
Alan Rasmussen
------------------------------
No RepliesBe the first to reply