SUMIFS with a date requirement included.

I have a Disbursement tracker, showing Request Status, Date Requested, Amount and Project. I have another sheet, Project Plan showing the summation of Disbursements by Project. I am currently using the formula below to summarize all Amounts that are disbursed. I am using my request status column and including everything other than "Sent to Management for Approval". This works but I think it would be easier to use a NOT formula, so NOT = "Sent to Management for Approval" and NOTBLANK.

Also, I am getting into year two on my disbursement tracker so I need to add a requirement that the date requested is in the current year (2023). Can I add this to the formula?

In summary, It is the Disbursed column formula on the Project plan that I want to fix. I want it to look at the Disbursement Tracker, See if the Project Task = @row, is NOT blank or sent to management for approval and it is in year 2023, then to consider it disbursed for the project plan. Thank you!


=SUMIFS({Partner Disbursement Request Tracker Total Request}, {Partner Disbursement Request Tracker Project}, =[Task Name]@row, {Partner Disbursement Request Tracker Request Statu}, ="Complete") + SUMIFS({Partner Disbursement Request Tracker Total Request}, {Partner Disbursement Request Tracker Project}, =[Task Name]@row, {Partner Disbursement Request Tracker Request Statu}, ="Receipt requested from Partner") + SUMIFS({Partner Disbursement Request Tracker Total Request}, {Partner Disbursement Request Tracker Project}, =[Task Name]@row, {Partner Disbursement Request Tracker Request Statu}, ="Funds sent to Partner") + SUMIFS({Partner Disbursement Request Tracker Total Request}, {Partner Disbursement Request Tracker Project}, =[Task Name]@row, {Partner Disbursement Request Tracker Request Statu}, ="Requested Payment from Tenfold") + SUMIFS({Partner Disbursement Request Tracker Total Request}, {Partner Disbursement Request Tracker Project}, =[Task Name]@row, {Partner Disbursement Request Tracker Request Statu}, ="Request Payment from AMH-US")

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!