Formula for IFERROR(Index(Collect based on 3 different unique columns.
Good Morning Smartsheet Community,
Current Formula: =IFERROR(INDEX(COLLECT({Pass/Fail}, {Sales Order Number}, @cell = SO@row, {Unit Part Number}, @cell = Part@row), 1), "")
Possible New Formula: =IFERROR(INDEX(COLLECT({Pass/Fail}, {Sales Order Number}, @cell = SO@row, {Unit Part Number}, @cell = Part@row, {Line Number}, @cell = Line@row), 1), "")
I simply need this formula to display data from a column on another sheet. We have (3) unique identifiers that I need to be recognized so that we track information correctly.
Sales Order/Unit Part Number/Line Number
It seems when I add the line number portion to the end it does not track things at all from my data sheet.
Apologies for this being a little vague, I have no problem sending pictures of my issue if needed.
Thank you for any help!
Answers

Hi @Matthew R
Can you send a screeshot of the columns you are refering?

The first picture is the three columns on my data sheet I need to all match from my "Source" sheet if you will. Ultimately, I need the formula to display whether the item Passed/Failed based on those 3 columns matching my "Source" sheet information. We do not always need all 3 columns filled out but in the times we do it is acting a little funky on the formula side of things.
Please let me know if you need anything else!

@Matthew R Are the columns alway filled from left to right? in your exemple there is always a "Unit Part number".
If it's the case for all of the lines, why do you need to check the other 2 columns ?

We have specific orders that are specially coded for different reasons. We also have a column that designates the type of inspection it is, if it is an order that is Coded then we would indicate it that way. I will send you a picture of that column as well.
Perhaps I could just use that column in the formula to get where I need to be?
Apologies if I am not explaining well enough.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!