BeginnerOperationsAbout 6 minutes
Sample data
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | SKU | Item | On hand | Reorder level | Unit cost |
| 2 | A-100 | Hinge 40 mm | 120 | 50 | 0.8 |
| 3 | A-110 | Bracket set | 18 | 30 | 4.2 |
| 4 | A-120 | Oak board | 6 | 10 | 22 |
| 5 | A-130 | Zinc pin | 300 | 100 | 0.15 |
| 6 | A-140 | Door handle | 9 | 12 | 7.5 |
Steps
Each formula is already filled in and calculated. Edit it and press Run to try your own version. Nothing is saved or uploaded.
Is the bracket set at or below its reorder level?
Result
Turn that into an action.
Result
Value of the bracket set in stock: quantity times unit cost.
Result
Value of everything on hand.
Result
How many products are below 10 units?
Result
How many boxes of 12 can you fill from the hinges?
Result
What to remember
Compare on-hand with a reorder level, then let IF write the action. Add a filter on the column and you have a purchase list.
Formulas used
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.