UNPARSEABLE ERROR MSG FOR SUMIF USED IN 2 SMARTHEET files

Somebody, please help. I tried all the different formulas. I m using two different files. need to multiply the specific unit total PO quantity.

Formula is =SUMIF({SMARTSHEET COMPRESSOR PO Range 2}, ''USM2309103702'', {SMARTSHEET COMPRESSOR PO Range 1})

Thanks

Answers

  • Kaveri Vipat
    Kaveri Vipat ✭✭✭✭✭✭

    Hi fehmi,

    You can use this formula to sum the qty of a particular SKU from the ‘SMARTSHEET COMPRESSOR PO’ sheet.

    =SUMIF({SKU}, SKU@row, {Qty})

    Where you can use @row as shown in the formula to automatically fetch the SKU in the current row rather than typing a SKU like ''USM2309103702'' manually.

    =SUMIF({SKU}, SKU@row, {Qty}).

    I hope this helps!

    Thanks,

    Kaveri Vipat

    Senior Associate - Smartsheet Development, Ignatiuz Software

    2023 Core Product Certified

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"

  • fehmi
    fehmi ✭✭

    Hi Kaveri, Thanks for your reply. Now it says "Incorrect Argument"?


    =SUMIF({SMARTSHEET COMPRESSOR PO Range 2}, SKU@row, {SMARTSHEET COMPRESSOR PO Range 15})


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!