Update onsite availability date in team schedule sheet
Update onsite availability date in team schedule sheet
Your onsite availability date in the tracking sheet goes stale, causing technician scheduling gaps. It updates the sheet weekly so coordinators can assign technicians ahead of the maintenance window.
Overview
Run a weekly job that recalculates the next onsite availability date and writes it directly into your team spreadsheet, removing manual edits and late changes. That keeps coordinators working from the same, accurate date and reduces scheduling conflicts ahead of maintenance windows.