Formula: if checkbox is checked then add or subtract
Hi everyone, I would like to have a sheet that tells me how many goods we have left in our warehouse.
The idea is that employees report via a dashboard whether they are taking something out of stock or returning something.
If one checks the column "IN" or "OUT" they also have to add the amount. That amount should be subtracted from the total quantity when taking something out of stock (if the "OUT" column is checked). The amount that they bring back must be added (if column "IN" is checked).
The formula should be in column "Quantity left".
I know this is certainly possible in smartsheet, but I can't put together the right formula.
Can anyone give me a solution or point me in the right direction.