=COUNTIF - Columns "A" & "B" Has "1" & "2" Values

A Rose
A Rose ✭✭✭
edited 12/02/20 in Formulas and Functions


How Can I count how many of the column "User" is "Jack" and the Column "Daily Email" is "Done"?

I want to make 1 calculation for both, how many users have these values.

I treid doing the following: (It didn't work..)

=COUNTIF(User:User, "Jack" + [Daily Email]:[Daily Email] "Done")

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!