If Statement for 4 columns

Is it possible to make a if statement that references four columns to make a decision?

I'm trying to make a if statement that basically will check if someone said yes to each choice for said animal. If they did I want to the decision column to say "Send Info", If not "Don't Send".


Answers

  • L_123
    L_123 ✭✭✭✭✭✭

    =if(or(dogs1 = "yes", Cats1 = "yes", birds1 = "yes", horses1 = "yes"),"Send Info", "Don't Send")

    Above is the one of the more basic methods of using this type of logic. You can also combine different formulas to perform this task a bit more optimized.

    =if(countif(dogs1:horses1,"yes")>0,"Send Info", "Don't Send")

    As an example.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!