Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Text String Missing Characters

Hi,

 

I have created a custom column to retrieve cells from another column that has more than 2 characters.

 

However the function is cutting the text string short. I have read up and the character limit is well beyond the character count I am trying to display.

 

IF(LEN('Forms Pro Question Responses'[Name])>2 ,'Forms Pro Question Responses'[Name],BLANK())
 
The text in the original Name column is displaying all characters.
 
Any suggestions greatly appreciated 😄

 

  • Anonymous's avatar
    Anonymous
    5 years ago

    I figured it out as I went to look for an example -_-. There are 2 columns from the data source and one has trimmed text

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I figured it out as I went to look for an example -_-. There are 2 columns from the data source and one has trimmed text

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous 

    This formula is working fine for me.

    Please check if you have your reference column('Forms Pro Question Responses'[Name]) is Text.