Help needed for SUMIF, Date Range



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



  • Kaveri Vipat
    Kaveri Vipat ✭✭✭✭✭✭

    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 


    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!