Forum Discussion

Betissa's avatar
Betissa
Icon for Helper I rankHelper I
9 years ago
Solved

help - how can i use condition ?

Hello everyone;

I would like to create a column1 in a table from another column0;
Column1 must contain letters as follows:
If a text field in column 0 starts with the letter A write A in column 1 if this field begins with the letter b write b otherwise write c.
I try the IF function but it accepts only one condition;
I also used the SWITCH function but it does not support the character strings;
Your suggestions?

2 Replies

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion

    hi Betissa

     

    Create a calculated column and use a Switch and Left Function.