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
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!