I have 2 different kinds of {App Pseud} formats, e.g.
kay_obsessive
goblin fic (Kiestan)
Then I have a formula to spit out a URL, where the concatenate is the important bit:
IF(OR({Work Submission Pseud}!={Synced Participant},{Assigned Writer(s)}=BLANK()),BLANK(),CONCATENATE("https://autoao3app.firebaseapp.com/#/mfd2021_round2/user/",SUBSTITUTE(TRIM({App Pseud})," ","%20")))
And it spits out these URLs:
https://autoao3app.firebaseapp.com/#/mfd2021_round2/user/kay_obsessive
https://autoao3app.firebaseapp.com/#/mfd2021_round2/user/goblin%20fic%20(Kiestan)n
The extra character on URLs where the app pseud has a parenthesis always matches the character just before the ). I don’t see what is causing it in the formula. Help!