IF / OR formula then Check a Box
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))
Best Answer
-
Give this a try:
=IF(OR([Study Status]@row = "Active/Open to Accrual", [Study Status]@row = "In Start-Up"), 1)
Answers
-
Give this a try:
=IF(OR([Study Status]@row = "Active/Open to Accrual", [Study Status]@row = "In Start-Up"), 1)
-
That worked! thank you, so much!
-
Happy to help!
-
@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)
-
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?
-
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
-
I think you missed the (see below) part of your comment.
🤔
-
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]
-
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: " "
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives