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)