draft

Prompt

Here's a prompt you can paste into a new chat. I haven't seen your original file, so I based it on what I know from your setup: an "on order material" spreadsheet with an "Updated PO ETA Date" column that feeds ServiceTitan job ETAs. Edit anything that doesn't match. ``` Build me a purchase order (PO) tracker for tracking on-order material for service jobs. Make it an Excel spreadsheet (.xlsx). COLUMNS (one row per PO line item): - PO Number - Vendor - Job / ServiceTitan Job # - Customer / Site - Item / Description - Qty Ordered - Qty Received - Order Date - Original ETA - Updated PO ETA Date (the vendor's latest promised date) - Ship Date / Tracking # - Status (dropdown: Ordered, Confirmed, Shipped, Delayed, Partially Received, Received, Cancelled) - Last Vendor Contact (date) - Notes (vendor emails, delay reasons) - Days Until ETA (formula) - Days Late (formula) BEHAVIOR: - Dropdown validation on Status. - Conditional formatting: red for past-due ETA and not received, yellow for ETA within 3 days, green for Received, gray for Cancelled. - Formulas for Days Until ETA and Days Late, and a flag when Updated ETA is later than Original ETA. - Frozen header row, filters on every column, sensible column widths, wrapped Notes column. - A "Summary" tab with: open POs by vendor, count of late POs, POs arriving this week, and POs with no ETA yet. - A "Received" tab (or filter view) so completed POs don't clutter the main list. Start with my existing data if I attach it, and keep the column names exactly as listed so I can sync the Updated PO ETA Date into ServiceTitan's "Updated ETA" field and check vendor emails against it row by row. If anything is unclear, ask me before building. ``` If you tell me the real columns, or attach an old copy of the file, I can tighten the prompt or rebuild the tracker here.