Loading...
Quick Links

Reply To: Custom Project Fields that are Filled in by Task Finish Dates

Home Forums Discussion Custom Project Fields that are Filled in by Task Finish Dates Reply To: Custom Project Fields that are Filled in by Task Finish Dates

#392539
Larry ChristofaroLarry Christofaro
Participant

Mollie, you can certainly calculate a date based on the Project Start date easy enough. It is a bit more tricky to roll-up a date within the schedule but can be done and I do it quite often. Try this:
1. Create a task custom flag field called something like “Key Project Task”
2. Set this task to Yes for the key task within your schedule. This will mark the key task
3. Create another task custom date field called “Key Project Date. Use a formula that states If “Key Project Task” = yes, Finish, else null. Roll this up to summary tasks as Maximum. This will set the task 0 task to the finish date associated with the key task.
4. One more step, create a Project custom date field that equals Key Project Date. This copies the results of the task field to the project field.

I know it sounds like a lot but it does work as long as you are limiting the number of fields you want rolled up. There are probably some blogs that explain this (and probably better) but I haven’t done a search.