Countif with multiple criteria

Krystab352
Krystab352 ✭✭
edited 04/17/23 in Formulas and Functions

I am trying to create a countif formula with multiple criteria with one being the approval status and the other being scheduled (which is a date and I want to count it as "1"). 

I'm trying =countifs(range1, "Approved") +countif(range 2, ???) 

The question marks if where I am having issues. The column is formatting as a date not text/number so that may be the issue. I tried =countifs(range1, "Approved") +countif(range 2, NOT(ISBLANK(@cell)) and it returned a wrong number.

Any suggestions? I'm getting really frustrated.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!