Incorrect Argument Set
Hello,
I don't know what is wrong with this formula. I receive the "Incorrect Argument Set" error.
=SUMIFS({Invoice Amount}, {Segment}, "All", {Requires JV}, "Y", {Invoice Date}, <DATE(2023, 7, 1))
Thanks,
Amy
Answers
-
Hi @Amy Evans, it looks right. I'm sure that each cross sheet reference is pointing to the same target page, but if not, you'll need to change that. Check that each of your cross sheet references is correctly set up (SS blinks sometimes when you are creating them and you end up having no column selected when you look back). Then I would just remove one reference at a time and see if one of them is the culprit..
-
It is working now. I'm not sure what happened. Maybe there were several people working on the target page and that confused the formula?
Thank you always for the quick replies.
Amy
-
Hi @Amy Evans
I hope you're well and safe!
Excellent! Glad you got it working!
Have a fantastic week & Happy Independence Day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!