How to reference Select and Multi-Select in Automations?

I couldn’t figure this out, I ended up using another table with the values for the Select, which worked but I lost the colour configuration and display.

So then I added a Select to that table, with the value and colour I wanted, then add the table as a relation, plus a lookup to the select :confused:

My question is, how can I avoid all that? Reusing the above example, how do I create/get/find or reference the “Campaign” type in a formula?
Just the name as a string doesn’t work, the index as an int etc :confused:
it tells me “Result type should be Mission Type Display but Text received”

Currently not possible without scripting I’m afraid, sorry.