OR formula---cell range

I have questions

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")

Heather Duff

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