OR formula---cell range

Options

Hello,

I'm having trouble with an OR formula. I want Smartsheet to read a range of child cells to populate the parent cell accordingly. However, the formula I have below isnt working. Thoughts.


=IF(OR(Status21:Status61 = "not started"), "Not Started", "In Progress")

Answers

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Options

    Hi @I have questions ,


    Try something like this:

    =IF(COUNTIF(Status21:Status61, "Not Started") >0, "Not Started", "In Progress")


    This translates to: If there are more than zero "Not Started" cells in Status21 through Status61, display Not Started; otherwise, display In Progress.

    Alternately, if you're indenting and rows 21-61 are the child rows of the row you're putting the formula in, you could use this:

    =IF(COUNTIF(CHILDREN(), "Not Started") >0, "Not Started", "In Progress")

    Hope this helps! Let me know if it works for you.


    Best,

    Heather

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!