Nested Or within Countifs formula

Hi,

I am hoping to see if I can get help with the following formula:

=COUNTIFS([Area of focus]:[Area of focus], "HGIT", Status:Status, "Complete", OR([Status:Status] = "Approved"), [Channel:Channel], <>"internal comms")

Essentially, my goal is to count items that are for "HGIT" that are either complete or approved but not related to internal communication. I am using the brackets in this example to illustrate an entire column.

Thanks in advance!


-Jake

Answers

  • =COUNTIFS([Area of focus]:[Area of focus], "HGIT", Status:Status, "Complete", Channel:Channel, <>"internal comms") + COUNTIFS([Area of focus]:[Area of focus], "HGIT", Status:Status, "Approved", Channel:Channel, <>"internal comms")


    Resolved my issue. Apparently you cannot nest an "Or" statement within countifs as it is an "and" based function.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!