IF / OR formula then Check a Box

Susan Swisher

I need a formula that IF a specific column has either 1 of 2 specific choices, then a BOX in another column is checked:

=IF(([Study Status]@row = "Active/ Open to Accrual", 1) OR([Study Status]@row = "In Start-Up", 1))

Carson Penticuff

Give this a try:

=IF(OR([Study Status]@row = "Active/Open to Accrual", [Study Status]@row = "In Start-Up"), 1)

Carson Penticuff

Give this a try:

=IF(OR([Study Status]@row = "Active/Open to Accrual", [Study Status]@row = "In Start-Up"), 1)

Susan Swisher

That worked! thank you, so much!

Carson Penticuff

Happy to help!

Susan Swisher

@Carson Penticuff One additional problem/question; can I have more than 2 OR is that a whole other problem?

=IF(OR([Study Status]@row = "Active/ Open to Accrual", [Study Status]@row = "In Start-Up"), [Study Status]@row = “Active/ Accrual Complete”), 1)

Carson Penticuff

More than two will not be an issue. Can you see how to add additional options from the existing formula, or do you need additional help?

Susan Swisher

So, I added the additional string (see below) and instantly got an error; so, I guess I need help. Do I need to add more IF(OR statements?

Susan

Carson Penticuff

I think you missed the (see below) part of your comment.

🤔

Susan Swisher

Should have said, see above (I wrote it in the comment above); but here it is:

=IF(OR([Study Status]@row = "Active/ Open to Accrual", [Study Status]@row = "In Start-Up"), [Study Status]@row = “Active/ Accrual Complete”), 1)

[I get an #unparseable error]

Carson Penticuff

My apologies, I completely missed that the formula was in the comment above. You had it very close.

=IF(OR([Study Status]@row = "Active/ Open to Accrual", [Study Status]@row = "In Start-Up", [Study Status]@row = "Active/ Accrual Complete"), 1)

There was one extra closing parenthesis. Also, be very careful about the type of quotation marks you use. You had these in your last option: “ ” but it needs to be these: " "