- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 04, 2023 03:01 PM
I created a master program plan in hopes to combine all of the project plans on my team, but I couldn't get the start date to auto-adjust based on the end date. My team used to use a spreadsheet in which we used this formula: =WORKDAY(H3,1,Holidays!$A$2:$A$10002) and this would auto-project how long the project would take based on the duration and previous task end date.
When I tried to replicate a similar formula, it's an error due to circular reference. Is there a way to do this without having to enter the start date every time? (example: when a previous tasks took longer than expected the new end date should trigger the future start date to autoadjust based on the duration).
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 05, 2023 10:22 AM
Yep, i am doing this right now. What you need to do is add a check box to lock in the date. Then filter out any records with the box checked from the automation hitting them again.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 07, 2023 11:29 AM
Thanks for responding! It didn't work for me, the start date is still taking the date from the same row where as I want it to from the row above. Perhaps you can show me an example or screenshot?
