Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
COUNTIFS and with 2 different values in same column?
I'm trying to create a formula to count when 2 different types of activity in a column ("Key Initiative" and "Initiative" have the value "Complete".
I've been trying different ways to organize COUNTIFS to solve the problem, but I'm getting either "0" or #Unparse as a result.
The most straightforward formula I've used is
=COUNTIFS(Type8:Type40, "Key Initiative", Type8:Type40, "Initiative", Status8:Status40, "Complete"
I get "0" as the answer.
Can anyone help me solve this?