Im trying to check the box in Column 2 with either TTP or TTV value in either Column’s 3 or 4 and th

Hobo

Kelly Moore

Hello @Hobo

It looks like your request was truncated. Are you trying to check the box if either columns have TTP or TTV in them? Is there more to the condition? If not, try the formula below.

=IF(COUNTIFS([Column 3]@row:[Column 4]@row, OR(@cell = "TTP", @cell = "TTV")) > 0, 1)

Will this work for you?

Kelly

Kelly Moore

Hello @Hobo

It looks like your request was truncated. Are you trying to check the box if either columns have TTP or TTV in them? Is there more to the condition? If not, try the formula below.

=IF(COUNTIFS([Column 3]@row:[Column 4]@row, OR(@cell = "TTP", @cell = "TTV")) > 0, 1)

Will this work for you?

Kelly

Hobo

Hi Kelly thanks this works perfectly!