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))



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