Formula with multiple conditions

Formula with multiple conditions

Hello Community;

I am trying to write a formula to check mark a field when 2 conditions are met; so far l have been able to make it work with 1 condition (see highlighted screenshot), but can't figure out how to add the 2nd condition to the formula...Any ideas???

Thanks!



Best Answers

Answers

  • @Andrée Starå

    does not want to work for me; l tried with both comma and semi-colon:



  • Andrée StaråAndrée Starå ✭✭✭✭✭
    edited 03/26/20

    My apologies, there was a typo.

    Try this.

    =IF(AND([Job Status]@row = "Complete", As-Built Submitted"; [2nd Condition]@row = "Condition"); 1; 0)

    The same version but with the below changes for your and others convenience.

    =IF(AND([Job Status]@row = "Complete", As-Built Submitted", [2nd Condition]@row = "Condition"), 1, 0)

    Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • @Andrée Starå


    I am not sure where the typo is, still tried with the coma, the semi-colon, the dot and getting the same error...



  • @Genevieve P It worked! For some reason when just editing the formula wouldn't work, had to re-write the whole thing and it works perfect... Thank you both!

    @Andrée Starå

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Silvia Rangel Ok, now I see!

    Happy to help!

    Glad you got it working!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.