OR function to check a box

I am trying to get one box to check under one or another conditions.

1. when a certain cell has any text

2. When another certain box is checked

The function I came up with follows, but it doesn't seem to work. There might be one small tweak I need to make, but I am still new to making formulas. 

Thanks for your help!

=IF((ISTEXT([What is your cultivation cycle?]196), 1), OR(Cancelled196 =true))


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Sarah,

    Try something like this.

    You were close. The order was a little off. I also added the @row function because so you don't have to think about the row numbers.

    =IF(OR(ISTEXT([What is your cultivation cycle?]@row); [email protected] = 1); 1)

    The same version but with the below changes for your and others convenience.

    =IF(OR(ISTEXT([What is your cultivation cycle?]@row), [email protected] = 1), 1)

    Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

    Did it work?

    Have a fantastic week!


    Andrée Starå

    Workflow Consultant @ Get Done Consulting


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.