AlanRasmussen
3 years agoQrew Member
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:
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:
------------------------------
Alan Rasmussen
------------------------------
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 (?) |
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
------------------------------