Formula with multiple conditions

Silvia Rangel

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!

Andrée Starå

Hi Silvia,

Try something like this. (Update the 2nd Condition Column name to what you are using)

=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.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Genevieve P.

Hi @Silvia Rangel

To add to Andrée's advice, it looks like you actually want an "OR" function instead of "AND", because you're looking for two possible selections (not two selections at the same time), is that correct?

Try this:

=IF(OR([Job Status]@row = "Complete, As-Built Submitted", [Job Status]@row = "Complete, As-Built Accepted"), 1, 0)

Andrée Starå

Hi Silvia,

Try something like this. (Update the 2nd Condition Column name to what you are using)

=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.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Silvia Rangel

@Andrée Starå

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

Andrée Starå

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.

Silvia Rangel

@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.

Hi @Silvia Rangel

To add to Andrée's advice, it looks like you actually want an "OR" function instead of "AND", because you're looking for two possible selections (not two selections at the same time), is that correct?

Try this:

=IF(OR([Job Status]@row = "Complete, As-Built Submitted", [Job Status]@row = "Complete, As-Built Accepted"), 1, 0)

Silvia Rangel

@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å

@Silvia Rangel Ok, now I see!

Happy to help!

Glad you got it working!