Need formula

If a cell is IN can you change a other value in a other cell into - or +

For example

when the warehiuse scan the goods in , and action is IN , and QTY 20 the qty 20 doesnt changes .

But when action is OUT the number he puts in the field is 6 but due to the action is OUT the number shoudl changes to -6

This make that i can create a warehouse overvieuw

Best Answer

  • Protonsponge
    Protonsponge ✭✭✭✭✭✭
    edited 12/10/24 Answer ✓

    Hello @TVP ALAN

    Would the following be an option for you? For each row, if [ACTION] equals "IN" then it will display the value in [QTY], if [ACTION] equals "OUT", it will display the negative value in [QTY].

    =IF(Action@row = "IN", QTY@row, IF(Action@row = "OUT", -QTY@row))

    I hope that is helpful to you in some way,

    Protonsponge

Answers

  • Protonsponge
    Protonsponge ✭✭✭✭✭✭
    edited 12/10/24 Answer ✓

    Hello @TVP ALAN

    Would the following be an option for you? For each row, if [ACTION] equals "IN" then it will display the value in [QTY], if [ACTION] equals "OUT", it will display the negative value in [QTY].

    =IF(Action@row = "IN", QTY@row, IF(Action@row = "OUT", -QTY@row))

    I hope that is helpful to you in some way,

    Protonsponge

  • super

    it works tomorrow i start scanning to test thank you very much

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!