I can't get my inventory to work the way I want it to. I work for a powder-coating company, so our inventory is dry, colored powder, tracked in pounds. Right now it looks something like this:
<tbody>
</tbody>
The powder manufacturer is in the first column, with their respective colors ranked below each in the next column. The third column is the current weight, in pounds, on hand. I want to add another column to reflect daily powder usage, in pounds,
<tbody>
</tbody>
And I'm fine to this point. Not all colors are used daily, and I don't subtract zero. But I want the form to update after I hit enter on each usage cell:
<tbody>
</tbody>
*ENTER*
<tbody>
</tbody>
I run into circular references when trying a =SUM('currentweight'-'usage')
This inventory is a mess! Someone please HELP!
Sherwin Williams | BK01 | 35 | |
BK03 | 47 | ||
Rodda | Gloss Black | 14 | |
Midnight | 55 | ||
Cardinal | RAL 7011 | 6 | |
RAL 7112 | 83 | ||
RAL 7003 | 17 |
<tbody>
</tbody>
The powder manufacturer is in the first column, with their respective colors ranked below each in the next column. The third column is the current weight, in pounds, on hand. I want to add another column to reflect daily powder usage, in pounds,
Sherwin Williams | BK01 | 35 | 7.5 |
BK03 | 47 | ||
Rodda | Gloss Black | 14 | 4 |
Midnight | 55 | 20 | |
Cardinal | RAL 7011 | 6 | |
RAL 7112 | 83 | 6.5 | |
RAL 7003 | 17 | 0.5 |
<tbody>
</tbody>
And I'm fine to this point. Not all colors are used daily, and I don't subtract zero. But I want the form to update after I hit enter on each usage cell:
Sherwin Williams | BK01 | 35 | 7.5 |
<tbody>
</tbody>
*ENTER*
Sherwin Williams | BK01 | 27.5 |
<tbody>
</tbody>
I run into circular references when trying a =SUM('currentweight'-'usage')
This inventory is a mess! Someone please HELP!