How to create a formula with multiple criteria with OR logic?

Options

Hi Team,

I would like to create some formulas with multiple criteria where some should work with OR logic. Could you advice if this is possible and how should I proceed?

Example:

From the sample data below, I would like to calculate: How many tasks there is that are being worked on (Task Phase is "Started" or "In progress") and at the same time are assigned to either Jane or Natalie.

Thank you in advance for suggestions!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!