Once again, a reminder to do this first in a copy of your app.
The first step is to create a formula duration field. I think that you have that already.
Then you convert that to be a duration field. When you change a formula field into a scalar field (a data entry field) Quick Base will drop the individual 5,000 duration calculations into the data. So you have not lost those durations.
Then, you will change the field type in the end date field to be a formula work date and make the formula. Then test every thing.
A comment, in my experience, it's a royal pain to do the predecessor relationships manually, so much so that people simply will not do it. So the only practical way is to have say project templates where the tasks are identified for the various standard project types, so that a user can grab a std template and click to create the set of tasks for their Project. Then adjust from there.
So just go into this knowing that if you have not done so already, you will need to be figuring out what your standard tasks sets are and a process to let users grab them into their Project record.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
