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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives