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))
Comments
-
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!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
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.
0