Quarterly Budget with SUMIF
Good Morning,
I am trying to use the SUMIF function to pull data from another sheet.
=SUMIFS({Budget Requests Range 1}, {Budget Requests Range 2}, "Software", {Q/Y Lookup}, [Q/Y]@row, "")
The other content is:
Budget Amount (Budget Requests Range 1)
Type of Request (Budget Requests Range 2)
Q/Y that the budget applies to (Q/Y Lookup)
Here is the source sheet for awareness (dummy data):
Also, I have helper columns to determine the Quarter and Year based on the Estimated Date of Charge field.
I also tried this formula:
=SUMIF(COLLECT({Budget Requests Range 1}, {Budget Requests Range 2}, "Software", {Q/Y Lookup}, [Q/Y]@row, ""))
Neither of these are working out and I would love a second set of eyes to tell me what I am not seeing.
Best Answer
-
What is the
, ""
for at the end of the formula? I'm fairly positive that's causing your incorrect argument set error. Remove the comma and blank quotes and you'll be good!(And thanks for including screenshots, the formulas you've tried, and the error message!)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
What is the
, ""
for at the end of the formula? I'm fairly positive that's causing your incorrect argument set error. Remove the comma and blank quotes and you'll be good!(And thanks for including screenshots, the formulas you've tried, and the error message!)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
@Jeff Reisman I feel so silly! Thank you! I missed that when I copied from another formula I was using, so I didn't have to retype everything.
Thank you! Thank you! Thank you!
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!