Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Character Number Validation

Hi!

I am working with KPIs and one of them needs two validations:

1) The cell from the source file shouldn't be blank

2) We have to take into consideration that, since this is a live file and it's changing multiple times in a day, sometimes the users populate the field with single characters like 1, A, etcetera.

What I thought would be a workaround was to use the LEN function to validate if the field (BCIT Clients) has more than 1 character.

I tried using it but it seems that I need to parse it first. Is there a function that can count characters from a string? I appreciate your help on this matter.

 

 

Need Help
Tips and Tricks

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    2 years ago

    Anonymous You have a parenthesis problem:

     

    IF( OR ( LEN( [BCIT Clients ) > 1, NOT ( ISBLANK( [BCIT Clients ) ) ), [Approved], 0 )