Custom column - two conditions

[DianaDSTM]

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

[DianaDSTM]

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.

[PhilipTreacy]

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