How do I get the characters before a specific character?
Let's say I have column username where the drop down is a list. A username is "JonSmith-81". I'd like the next line item, lets call it alias, to just pull "JonSmith" from this string. The alias line item is formatted as text. What would be the formula to return just "JonSmith" in alias line item? I seem to get an error due to the mismatch in formatting.
I believe we answered this in your previous post on Friday...
I forgot to mention the formats of the field and the solution provided didn't work due to the formats, as so it seems.0
Then use the name() function around the User Name which is list formatted.0