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))
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:
[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: " "
ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.
