Nested Crtiteria

Karrie Davis
Karrie Davis Overachievers Alumni
edited 12/09/19 in Formulas and Functions

Hi, 

 

I'm trying to write a formula that would give me the total Number of request by person, that does not include Completed or abandoned. I used the following formula and it come up as nested criteria. 

=COUNTIFS({Status}, @cell <> $[Primary Column]7, {Owner}, @cell = "Erica" + COUNTIFS({Status}, @cell <> $[Primary Column]8, {Owner}, @cell = "Erica"))

 

nested criteria.PNG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!