If Formular

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!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!