if (function)

the if() function can handle if/else if/else functionality inherently.  If given more than 3 parameters (if/then/else), the subsequent odd-numbered parameters [except the final one] will each be evaluated as a new condition.

if(
  ri!colorIndex = 1,
  "Red",
  
  ri!colorIndex = 2,
  "Green",
  
  ri!colorIndex = 3,
  "Blue",
  
  "Something else..."
)

For example, the above code will evaluate to "Red" for an input of 1, "Green" for an input of 2, "Blue" for an input of 3, and for any other input value, it will return the default return value of "Something else..."

NOTE: as mentioned down-thread, this functionality is not officially supported or documented, so use it with caution if at all. (/edit)

Is this a supported "feature" as it does not appear to be mentioned on the help page?

I'm with you, Gavin - if it's not in the documentation then it is not officially supported. I've encountered a similar 'bending' of the index() function where you can provide a list of values as way of navigating a tree-structure, and having asked Appian Engineering about this I had the same response - the documentation says it only takes 3 parameters and that's how far the official support will take you.

I'm with you, Gavin - if it's not in the documentation then it is not officially supported. I've encountered a similar 'bending' of the index() function where you can provide a list of values as way of navigating a tree-structure, and having asked Appian Engineering about this I had the same response - the documentation says it only takes 3 parameters and that's how far the official support will take you.