Let me explain the problem statement.
-
We have a project approval board where there is a field called “Probable Start Date” which is filled by the user via Form. The column type is date.
-
Once the project is approved, the Project Schedule is created via a template which has a column called “Start Date”. Once the Project is approved, this “Probable Start Date” should be considered as the “Start Date” of the project.
-
There is also a “Duration” column which has the duration of each activity in Days. The type of column is “Numbers”.
-
There is another column called as “Finish Date” Column which is formula column (Finish Date = Start Date + Duration)
-
Now here is the issue, all the above is working well for the first activity in the project schedule. But for the second activity onwards, the Start Date should be Finish Date of Previous Item + 1 ( because let’s say the previous item finish date is 19th October and hence the start date of next item would only be the next day ie 20th October and hence “+1” )
-
Once the Start Date is populated for the second item via the above formula (point no 5), and the duration for each activity is mentioned, it should keep on calculating the Finish Date and subsequent start date for the remaining items on the board.
