I'm hoping someone can help me out here. I'm looking for a formula to calculate how many items have been sold but have not been shipped. Example:

I want it to add the #s in the Color column of all lines where WH Location = 8A-8Z unless "Shipped" is in the Vendor column.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!