Linking Construction Program line items to relevant task lists
I'm working for a design and construct fit out company and we're looking to invest in control center and I'm just looking at the configuration of the project workspaces and need some ideas for the following scenario....
Each project has a construction programme which is shared with the client. Within that program there are a number of key events related to our drafting and procurement teams. However through out the project there are a lot of extra subtasks or action points for each of these departments and extra details to be collected that are for internal reference and we don't want inc on the main program. Just looking for suggestions on how to get the points and dates from the program to a drafting or procurement task list but still keeping the main program dates live and accurate on the relevant task lists.
My only thought would be to set up a rule when a program was finalised and perhaps a 'create task' checkbox was ticked on the main program the row copies to the necessary task list and it is the drafter or project managers responsibility to manually link the start and end date on their task list back to the main program so it stays live as things are pushed out in the program. Would be glad of any other suggestions that don't requite the manual cell linking though!
Help Article Resources
Check out the Formula Handbook template!