Combine strings and logic in formulas

[jn08]

Is there any way to do this? For e.g. to have a list of if statements that output a comma separated list? Have tried using & but it throws an error.

[Elias_Gomez_Sai]

Where does that comma separated list come from?

[jn08]

I’m basically wondering if I can use IF statements within string operations to create more complicated concatenated fields. For e.g.:

SUBSTITUTE(TRIM({Title Prefix} & " " & {Title Only} & IF({Subtitle} = BLANK(), "", ":" & Subtitle), " ", " ")

This should return a title whether it has a prefix or a subtitle formed correctly, including a colon if the subtitle is present. But it throws up an error. Is there a way to do what I’m trying to do here?

[Andy_Lin1]

Hmm, it looks like your TRIM function isn’t closed (there should be a second close parens after Subtitle).
Not sure about the substitute function, is it replace a regular space with a special space character?

[jn08]

So I did! Thanks for this. I thought perhaps the error was not being able to have more complex formulas, but now that I know it’s fine it’s mad a massive difference!