The Scenario
You are a project manager. One of your largest enterprise implementations just slipped by two weeks due to a vendor delay. The project has eight phases. All of them need their start and end dates pushed forward by exactly fourteen days.
You have already calculated the revised dates in an Excel workbook — phase ID in column A of the Rebaseline tab, new start date in column B, new end date in column C.
The slow version:
- Open the project in Rocketlane, navigate to phase one
- Click Edit, update start date, update end date, save
- Navigate to phase two, edit both dates, save
- Realize you set phase four's start date a day early
- Go back, correct it
- Eight phases, forty-five minutes, one error you might not catch until the customer notices.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the rebaseline workbook and pushes every phase date update to Rocketlane in one pass.
Open the SheetXAI sidebar and type:
For all 8 phase IDs in the Rebaseline tab (column A), update the Rocketlane start date from column B and end date from column C in a single pass.
SheetXAI reads all eight rows and calls Rocketlane once per phase with the correct dates. All eight phases are rebaselined in one prompt.
What You Get
Eight Rocketlane phases rebaselined, in one prompt:
- New start date — set to the value in column B for each phase
- New end date — set to the value in column C for each phase
- All phases in one pass — SheetXAI works through every row in column A
After the prompt runs, add a column D to log "UPDATED" so you have a confirmation record.
What If the Data Is Not Quite Ready
Rebaseline workbooks are rarely clean the first time.
When you have phase names instead of phase IDs
For each row in the Rebaseline tab, look up the Rocketlane phase ID using the phase name in column A under project ID in cell E1. Then update the start date to column B and end date to column C. Write the resolved phase ID to column D.
When the slip is a fixed number of days and you want dates calculated automatically
For each phase ID in column A of the Rebaseline tab, read the current start and end dates from Rocketlane, add 14 days to each, and update the phase. Write the original start date, original end date, new start date, and new end date to columns B through E.
When you also need to shift the tasks inside each phase
Pushing phase dates without shifting tasks leaves the project internally inconsistent.
For each phase ID in column A of the Rebaseline tab, update the start date to column B and end date to column C. Then shift every open task due date inside that phase forward by the same number of days as the phase moved. Write the count of tasks updated to column D.
When the rebaseline covers multiple projects at once
The vendor delay affected three projects, each with eight phases. You have all twenty-four phase IDs in the Rebaseline tab.
For all 24 phase IDs in column A of the Rebaseline tab, update the start date from column B and end date from column C. Process all rows in one pass and write "UPDATED" to column D for each phase changed successfully.
SheetXAI works through all twenty-four rows in one prompt, regardless of which project each phase belongs to.
Try It
Get the 7-day free trial of SheetXAI and open your rebaseline workbook, then ask it to push the updated dates to all eight Rocketlane phases. The Rocketlane integration is included in every plan. For related workflows, see how to bulk-update project dates and status from a workbook or the Rocketlane in Excel overview.