Cell referencing in a IF(CONTAINS(OR())) statement

Hello everyone ,

I am trying to use the @cell operator in my sheet , but I am cross referencing sheets and getting an invalid operator I am wondering if I am using incorrect syntax within my function , or braking the rules of the language . If someone could help me correct the formula that would be great !

=IF(CONTAINS(OR("QC " = @cell, "Disposition" = @cell, "Delay" = @cell, "Pending" = @cell), INDEX(COLLECT({Status}, {Lot}, [Int Lot]@row), 1)), INDEX(COLLECT({Status}, {Lot}, [Int Lot ]@row), 1), "Not Started")

Find more posts tagged with

functionality

Accepted answers

All comments

Paul Newcome

How exactly are you wanting this formula to work?

Miguel Lopes

@Paul Newcome I wanted the formula to search for those specific status key words in another sheet and then if they are true to display that current status on another sheet if those values are not found to display "Not Started".

Thank you !

Paul Newcome

Are you trying to match on something? Are you able to provide some screenshots for reference?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.