I am trying to remove certain characters or only display certain characters within a list. The source field is called [Issue Status] and created a calculated column with the following:
However, this error appears: "The formula contains a syntax error or is not supported. " Even when I try this following, still get the same error message!
=LEFT([Issue Status],LEN([Issue Status])-3)
Info: the issue status contains 6 characters in total. However, the length of this may vary depending on other used words.
Whereas using the simple
=LEFT([Issue Statys]) works and shows only the 1st character. I am confused and now sure how to get this resolved.
The source type of the source column is [Choice] but I also tried it with another source column type [Single Line aka. Text]. and no luck.