IF Statement?

Can someone help me with this formula please.

I have a monthly request list with open tasks. At the end of the month (example: February 28th), I need to calculate how many requests were still open at that time. I am trying to incorporate the date opened with the request status of Open by the Month using an IF statement - maybe it should be COUNTIF. By the information below, it would appear there are 7 requests still open but I cant figure out how to populate the formula. Any help is appreciated.

Thank you!

Answers

  • Danielle Arteaga
    Danielle Arteaga ✭✭✭✭✭✭

    Not sure how you have your columns formatted, so there may be more efficient way to go, but I think this will work for you:

    =COUNTIFS([Request Status]:[Request Status], "Open", [Month Opened]:[Month Opened], "2")

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!