Comments
-
Okay, I see, thank you! You were right, that cell was blank which was giving me blank for all. I added the WO#s and it works. I greatly appreciate your time and help with this.
-
Sure thing, here you go this is the formula currently in WO#: =INDEX({Template - Primary - Work Order}, MATCH(Spot@row, {Template - Primary - Name (no spaces)}, 0)) When I manually type in SpotName2 into "Spot" column i get blank cell in WO#, same.
-
I checked, still getting no value in WO# Column. I think the issue lies in the JOIN DISTINCT COLLECT formula, the index match is not seeing a match. When I make the "Spot" formula invalid the "WO#" formula sees it. Column "Spot" =JOIN(DISTINCT(COLLECT({Template - Primary - Name}, {Template - Primary - Name},…
-
okay thanks, let me check this and I'll get back.
-
That still works, thank you, but when I reference that cell in this formula in WO# column, it still returns blank: =INDEX({Template - Primary - WO}, MATCH(Spot@row, {Template - Primary - Condensed Name}, 0))
-
Thank you, this is the JOIN formula that is currently working: =JOIN(DISTINCT(COLLECT({Roseville - Reference Sheet Range 2}, {Roseville - Reference Sheet Range 2}, CONTAINS(@cell, [Asset Filename (copy here)]@row)), " "))
-
Yes please, would make life much easier with "internal" sheets set-up.
-
This is great, thank you for your help with this!
-
This is works perfectly, thank you!