If Formular

Options

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

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 02/08/21 Answer ✓
    Options

    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)



    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!