Operations template
Purchase Order Tracker Template
Track what you've ordered and what's still on the way. Open order value is totalled automatically.
Opening a template uses no credits.
What's inside
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | PO | Supplier | Amount | Delivered |
| 2 | PO-201 | Supplier A | 18,000 | Yes |
| 3 | PO-202 | Supplier B | 9,400 | No |
| 4 | PO-203 | Supplier C | 22,500 | No |
| 5 | Open orders | =SUMIF(D2:D4,"No",C2:C4) | =COUNTIF(D2:D4,"No") |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
C5 =SUMIF(D2:D4,"No",C2:C4)
Value of orders not yet delivered.
D5 =COUNTIF(D2:D4,"No")
Number of open orders.
Make it yours by asking
Try a request like this in Tabstra:
"Create a purchase order tracker with PO number, supplier, amount, order date, delivered status and total open orders"