Sum if status is approved and end date is in the future

mccoy_FSI
mccoy_FSI ✭✭✭✭
edited 01/25/24 in Formulas and Functions

I am trying to get the sum of approved projected expenses only. I can't figure it out I have been trying SUMIFS and SUM(AND formulas but can never get it to return a result. I can get one or the other to work, but it's important that only approved future expenses are summed. Below is a screenshot of the columns I'm working with.

I want to look at the approval status column for approved items only, and the end date column for future items only and then sum the projected expense column.


Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!