Trying to build an app that will allow me to enter the PO Qty, enter daily delivery amounts and track remaining balance to deliver. I’m having the hardest time figuring out AppSheet formulas to make this happen. Any help would be greatly appreciated.
This is what it looks like in Google Sheets.
| PO# | Customer | Job Name | Awarded Date | Area | Projected Start | Status | Material | PO (Qty) | Date Shipped | Daily Qty Shipped | Total Shipped To Date | Balance |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12345 | Winston | Parkway Plaza | 2/1/2023 | MCO | 2/20/2023 | Shipping | Limerock | 5,000.00 | 2/20/2023 | 500.00 | 500.00 | 4,500.00 |
| 2/21/2023 | 600.00 | 1,100.00 | 3,900.00 | |||||||||
| 2/22/2023 | 400.00 | 1,500.00 | 3,500.00 | |||||||||
| 2/23/2023 | 500.00 | 2,000.00 | 3,000.00 | |||||||||
| 2/24/2023 | 600.00 | 2,600.00 | 2,400.00 | |||||||||
| 2/27/2023 | 400.00 | 3,000.00 | 2,000.00 | |||||||||
| 2/28/2023 | 700.00 | 3,700.00 | 1,300.00 | |||||||||
| 3/1/2023 | 300.00 | 4,000.00 | 1,000.00 | |||||||||
| 3/2/2023 | 700.00 | 4,700.00 | 300.00 | |||||||||
| 3/3/2023 | 300.00 | 5,000.00 | 0.00 |