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 a Google Sheet — phase ID in column A, new start date in column B, new end date in column C. All eight rows, all correct.
The alternative is clicking into each phase in Rocketlane's UI, updating two date fields per phase, and hoping you do not make a typo on phase six.
What that looks like:
- Open the project in Rocketlane, navigate to phase one
- Click Edit, update start date, update end date, save
- Navigate to phase two
- Edit, update 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 sheet and pushes every phase date update to Rocketlane in one pass.
Open the SheetXAI sidebar and type:
Update the Rocketlane phase IDs listed in column A of the 'Phase Reschedule' sheet — set the new start date from column B and end date from column C for each phase.
SheetXAI reads all eight rows and calls Rocketlane once per phase with the correct dates. All eight phases are updated in one prompt, with no manual clicking and no typos.
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 sheets are rarely clean the first time.
When you have phase names instead of phase IDs
Your sheet was built from the project plan document and uses phase names, not Rocketlane phase IDs.
For each row in the 'Phase Reschedule' sheet, 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 for each phase. Write the resolved phase ID to column D.
When the slip is a fixed number of days and you want the dates calculated automatically
The instruction is "shift everything by 14 days" rather than using a sheet with explicit new dates.
For each phase ID in column A of the 'Phase Reschedule' sheet, 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 as a before-and-after record.
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 'Phase Reschedule' sheet, 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 sheet across three blocks.
For all 24 phase IDs in column A of the 'Phase Reschedule' sheet, 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 that was 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 sheet, 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 sheet or the Rocketlane in Google Sheets overview.