Discrepancy Qty from 2 column's

Options

Hi I need some help.

I'm self trained and only been using SS for a couple of years, so sorry if this sounds stupid.

I have 3 columns Qty AX, QTY WMS & Discrepancy Qty. If the qty in either of the first 2 columns differ I want the difference to be applied to the 3rd column.

AX could show 20 WMS could show 100 and visa versa I just need the Discrepancy Qty to auto fill

I think this will be easy but I just can't get my head round it! Many Thanks in advance :-)

Best Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @sue ponter

    I hope you're well and safe!

    Try something like this.

    =[Qty AX]@row - [Qty WMS]@row

    Did that work/help?

    I hope that helps!

    Have a fantastic week & Happy New Year!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    Hi @sue ponter

    Hope you don't mind if I hop in here, @Andrée Starå!

    Instead of copy/pasting, try clicking on the cells in the referenced columns to bring them into your formula - that way it will automatically grab the column name in the correct syntax 🙂

    You could also get a little fancier with the formula if you didn't want a negative number to show up when the MAX number is on the other side:

    =IF([Qty AX]@row >= [Qty WMS]@row, [Qty AX]@row - [Qty WMS]@row, [Qty WMS]@row - [Qty AX]@row)


    This checks to see if AX is greater than WMS, and if it is, then it subtracts WMS from AX. Otherwise, if WMS is greater, it subtracts AX from WMS. Does that make sense?

    Cheers!

    Genevieve

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!