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"

 

Thank you much

 

LD

  • az38's avatar
    az38
    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

2 Replies

  • az38's avatar
    az38
    Community Champion
    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