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
-
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⬆️"
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!