IF / OR Formula issue

I have a ticket tracker that I need and IF, OR formula to determine if either field has a Yes.

My formula works, but will only show Yes if BOTH of the other fields are Yes. I need it to say Yes if either of them are Yes.

=IF(OR([Started MRR less than $500?]@row = "Yes", [MRR Change less than $300?]@row = "Yes"), "Yes", "No")

Can someone help me?

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    Hi @Meghan Davis

    Hope you are fine, please try the following formula:

    =IF(OR([Started MRR less than $500?]@row = "Yes",[MRR Change less than $300?]@row = "Yes"),
    "Yes", "No")

    the following screenshot shows the result:

    PMP Certified


    ☑️ 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"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!