Formula Help

e.mcinnes66356 · 03/15/19

I am trying to have a formula in a cell that will total "1" if the Assigned to Column is a certain name, and the Status Column is QA, or fielded.

This is what I have and I need Help please..... I know it is so wrong but I am lost on how to correct it.

=IF(STATUS672 = "QA" OR(STATUS672 = "FIELDED"AND([QA Assigned To]672 = "Bill"), "1")

e.mcinnes66356 · 03/15/19

I have come up with this, but I can't get the OR condition for the Status Column for (STATUS672 = "QA") entered without UNPARSEBLE showing up.

=IF(AND([QA Assigned To]672 = "Bill", (STATUS672 = "FIELDED")), "1", "0")

Jacques@SBP · 03/17/19

The way to do an OR with IFs is to do a "nested IF". Try this:

=IF(STATUS@row = "QA", 1, IF(AND([QA Assigned To]@row = "Bill", (STATUS@row = "FIELDED")), "1", "0"))

e.mcinnes66356 · 03/17/19

That worked Perfectly, Thank you so much!

e.mcinnes66356 · 03/17/19

actually it only worked in Bill's column, when I copied the formula to Lorne's column and put his name in it still showed a 1 count even though it was Bills name in the QA Assigned to column.

And when the status changes to submitted it still shows 1 . I only want a count of 1 to enter into the cell if the status is QA or Fielded

Paul Newcome · 03/18/19

Give this a try...

=IF(AND([QA Assigned To]@row = "Bill", OR(STATUS@row = "QA", STATUS@row = "FIELDED")), 1)

Formula Help

Comments

Categories