Help needed for SUMIF, Date Range
Hello
I am having trouble with the below formula to return date based on a date range and getting a return of #invalid operation. I checked this out in the community but not able to find a resolution.
=SUMIFS({All PM PO Tracker-Assigned To}, "Project Manager", {All PM PO Tracker- Change Order-Submitted}, "Invoiced", {Telaid- All PM PO -Sent to Invoice Date} >= DATE(2023, 1, 1))
Appreciate the help in advance
Answers
-
Hi @ Andrew Taglauer
I have seen your problem statement, it seems you want to return dates but applied the SUMIFS formula here to provide you with the solution, can you please share images of the sheet where you are trying to apply the formula?
It will be beneficial to understand it in a better way.
Thank you
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⬆️"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!