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

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!