Index Collect Simplification

Pestomania

Hello,

I have a formula running a few different if formulas that I'd like to simplify if possible:

=IFERROR("MTD: " + IF(INDEX(COLLECT({MTD}, {Dallas Process Name}, Description@row), 1) <> "", INDEX(COLLECT({MTD}, {Dallas Process Name}, Description@row), 1), "Und")

+ ", RPO: " + IF(INDEX(COLLECT({RPO}, {Dallas Process Name}, Description@row), 1) <> "", INDEX(COLLECT({RPO}, {Dallas Process Name}, Description@row), 1), "Und")

+ ", RTO: " + IF(INDEX(COLLECT({RTO}, {Dallas Process Name}, Description@row), 1) <> "", INDEX(COLLECT({RTO}, {Dallas Process Name}, Description@row), 1), "Und"), "")

Paul Newcome

Can you describe what the intent of the formula is? Based on how I am reading it, that is about as efficient as it gets to generate what I see as the output.

Paul Newcome

Can you describe what the intent of the formula is? Based on how I am reading it, that is about as efficient as it gets to generate what I see as the output.

Pestomania

I ended up breaking it into different columns and got this to work easier.

=Min(INDEX(COLLECT({MTD_Rating_Tulsa}, {CMDB_Application_Name}, name@row, {MTD_Rating_Tulsa}, ">0"), 1)).