Multiple Criteria

Options

I'm trying to apply COUNTIFS condition with multiple criteria with same column:

Column (assigned to): abcd@xyz.com

Column (stage): is not one of --> blank and approved

Column (product stage): is not one of --> blank and 0


=COUNTIFS({SF PM Data Range 3}, "abcd@xyz.com", {SF PM Data Range 5}, <>"", {SF PM Data Range 4}, "0)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!