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
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!