IF OR Function for more than two fields or values

Options

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

Answers

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

    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 ✭✭
    Options

    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!