Sum only open orders with "Open" status.

It is possible for POs to have several different part numbers on it, as well as the same part number be on multiple POs. It is also possible for POs to be partially complete, therefore, each line item has its own status.

I am wanting to get the total number of each part needed to put on the schedule. The issue I am running into is, if the first instance of a part number that is in our master order log is "Closed", it ignores any other instance of that part number that may be in the log.

What is the best way to work through this problem?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!