Checking a box on all rows that meet a certain critera.

C. Ruiz

Hi, I'm in need of a formula that checks a box if the "Current Status" Column on all matching "Lab" "Number" columns that are marked as "Review Complete".

For example in the screenshot below I have lab number CD722 in 4 different rows. When each of those row's "Current Status" is marked as "Review Complete" I would like there to be another checkbox column that gets marked on each row so that I can set up an automation to move those rows to a new sheet, but only if all CD722 rows are marked as "Review Complete"

Paul Newcome

Try this:

=IF(COUNTIFS(Lab:Lab, @cell = Lab@row, NUmber:Number, @cell = Number@row, [Current Status]:[Current Status], @cell = "Review Complete") = COUNTIFS(Lab:Lab, @cell = Lab@row, NUmber:Number, @cell = Number@row), 1)