Index Collect Simplification

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"), "")
Best Answer
-
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.
Answers
-
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.
-
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)).
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 432 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!