Finding Data in 2 Columns

Options
Kyle Lewis
Kyle Lewis ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

Hi,

I am having trouble finding data that meets certain criteria across 2 columns. I have several status's that have "In Process" included in the column "Status". I also have a column named "Priority" with several priority levels. 

I need to find how many cells have "Low" in the Priority column AND have "In Process" in the Status column. 

Attached are screenshots of my Priorities and Status's

Here is the formula I attempted :=COUNTIFS({Beaumont FS/PM Range 1}, "Low", FIND("In Process", @cell) > 0)

Any help is appreciated. 

Kyle

Priority.PNG

Status.PNG

Comments