I want to create a formula to reference 2 columns in another sheet.

HI. I am looking to create a formula that will reference another sheet called Minor Issues Log. I want to record in my sheet if a full NCR was required by referencing the column "Is a full NCR required" and searching for "yes" and also reference a second column the other sheet called "Area / Dept". The end result i am looking for is a list of how many Minor Issues went on to require a full NCR against each department. The formula i have so far is =COUNTIF({Minor Issue Log Range 3}, "Yes", AND({Minor Issue Log Range 2}, "Mould")), but this is returning #INCORRECT ARGUMENT SET. Can anyone help please?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!