kstaver✭

I am making some progress, but I am still having some issues. I have this formula: =INDEX({ES1 Flat BOM Range 1}, MATCH({ES1 Flat BOM Range 2},@row, {ES1 Flat BOM Range 3}, 0)) I am getting the #UNPARSEABLE error I attached 2 screen shots: 1 of each sheet. I want to bing in the Primary Vendor information from the ES1 Flat…

@Andrée Starå I have one more question. Working on the same sheet. If I want to total up the number if issues per row. What is the best formula for that? Thanks for all your help. I have the most beautiful dashboard now tracking our Testing process.

Thanks!

那工作!我试一试ing to get away from needing to specify each row individually. Do you use a text editor or a different tool to write out long strings of formulas?

Hi @Andrée Starå Ok, so I can have a report that combines someone's individual task list plus tasks assigned to them on various projects. I have reports that consolidate tasks as part of our programs/projects (engineering change process, new product development etc), it has just been a bit of a mess trying to combine…