Equipment service dates — checked every morning, with alerts
Every morning the scenario reads the equipment sheet, finds devices coming due or overdue, alerts the technicians and supervisors and keeps a log.
- The check runs daily, not from memory
- Critical devices are separated — supervisors are warned about those
- Overdue items get their status flipped right in the sheet
- Alerts go out both by email and by message
Google Sheets
GmailJivo