Multiple Criteria


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

Column (assigned to):

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}, "", {SF PM Data Range 5}, <>"", {SF PM Data Range 4}, "0)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!