Forum Discussion

DianaDSTM's avatar
DianaDSTM
Regular Visitor
2 years ago

Custom column - two conditions

Hi, I'm trying to add two conditions using the custom column format, however keep getting an error under "and".

 

 

Need Help

2 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    2 years ago

    Hi DianaDSTM 

     

    Use double quotes like this, not the fancy curly ones in your image

     

    if [Condition 1] = "OK" and [Condition 2] = "OK" then "OK To Pay" .......

     

    regards

     

    Phil

  • DianaDSTM's avatar
    DianaDSTM
    Regular Visitor
    2 years ago

    Hi PhilipTreacy

     

    Thanks for your reply. I re-wrote it all again but then the error was at the end of the sentence. However, I checked on google and apparently where theres an "if" there must be a "then" and an "else" so I added "else null" and now it seems to have worked.