Help needed for SUMIF, Date Range

Options

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

Tags:

Answers

  • Kaveri Vipat
    Kaveri Vipat ✭✭✭✭✭✭
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!