If Formular

Christine Menke

Dear Expert,

I need help on below formular.

I try to get a column flagged, if this 2 arguments are fullfilled:

Factory column is "Yes" and and status is "Released"

I tried this:=IF(AND([article creation date]@row = "Released", [Dev Factory]@row = "Yes"), 1, 0)

But it shows also a flag if only 1 part is fullfilled.

Where is my mistake?

Thanks a lot for your help!

Christine

Bassam Khalil

Hi @Christine Menke

Hope you are fine, i used the following formula and its work.

=IF(AND([article creation date]@row = "Released", [Dev Factory]@row = "Yes"), 1, 0)

Bassam Khalil

Hi @Christine Menke

Hope you are fine, i used the following formula and its work.

=IF(AND([article creation date]@row = "Released", [Dev Factory]@row = "Yes"), 1, 0)

Christine Menke

Thanks a lot Bassam.M Khalil

I just found my mistake ( I used the wrong column instead of "article creation status" I marked "article creation date". Now it works :-)