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")
Answers
-
How exactly are you wanting this formula to work?
-
@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 !
-
Are you trying to match on something? Are you able to provide some screenshots for reference?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!