Nested CountIf function

Hi there.

Is there a such thing as a nested countif function?? I'm aware of how to use the countif in smartsheet...

=COUNTIF({ Test Sheet Range 3}, "Approved")

Suppose I want to count records with more than 1 criterion?

Status = Approved

Stage = Stage 1

How would I craft that out? Is it a nested CountIF function??

Thanks, SB


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!