SUMIF trying to bring formulas over from excel
=SUMIF('Invoice Log'!B$4:B$10405,E22,'Invoice Log'!E$4:E$10405)
I have two sheets. One is a log and the other is entitled "Invoice Log" . I'm trying to do the same in Smartsheet but i'm still getting the error Unparseable.
Comments
-
Hello,
Cross-sheet formulas work differently in Smartsheet than excel. Please check out our help article for more information on how to create a cross-sheet formula in Smartsheet: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets
I'd also recommend checking out our article on creating formulas for details on how formulas work in Smartsheet (there are some differences between Smartsheet formula construction and excel): https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet
Also, here's our complete functions list in Smartsheet: https://help.smartsheet.com/functions
Let me know if you're still having issues rebuilding this function in Smartsheet after reviewing the above.
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