Forum Discussion

LD's avatar
LD
Frequent Visitor
6 years ago
Solved

If / AND Condition

Hi, Please, I have three colums with two Date (A and B) and a status (C=TEXT). I need to develop following condition:   IF [Col. A]<=[Col. B] and [Col. C]="Complete" then "True" other "False"   ...
  • az38's avatar
    6 years ago

    Hi LD 

    it should be easy

    Column = IF([Col. A]<=[Col. B] && [Col. C]="Complete", TRUE(), FALSE())

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution