IF OR Function for more than two fields or values


Dear all,

I have a main task with several (3 or 4) sub tasks and want the top tasks' status to be changed, as soon as one of the sub tasks' status is being changed.

The following formula works, in the field of the main task, for only two sub tasks

=IF(OR(Status11 = "In Progress", Status12 = "In Progress"), "In Progress", "Not Started")

I would need something like:

=IF(OR(Status11 = "In Progress", Status12 = "In Progress", Status13 = "In Progress", Status14 = "In Progress"), "In Progress", "Not Started")

... but that doesn't work.

Do I understand correctly that an OR query only is valid for two criteria? What function do I use to check more than two field values? I would need something like "IF ONE OF..." but I can't find anything like that. Or do I have to add several IF queries to receive the wanted function?

Any hint is highly appreciated. Thank you very much! 😘

Best Answer


  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓

    Are the sub-tasks setup as children of the main task? If so, this should work:

    =IF(CONTAINS("In Progress", CHILDREN()), "In Progress", "Not Started")

  • MarkFX
    MarkFX ✭✭

    Wow Carson! 😀 THAT is exactly what I was looking for! 😊

    And it's SO easy! Thank you very very much! If I could, I would buy you a beer now!

    Awesome! Thank you Carson!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!