UNPARSEABLE ERROR MSG FOR SUMIF USED IN 2 SMARTHEET files

fehmi

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

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!

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})