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.