IF Clause formula based on different table

[Sara]

Hi everyone, I'm really bad with the formula field!
I'm trying to create a formula that prints "OK" if each user that I added has an active status; if some users have inactive status, print "not everyone," and if nobody has an active status, print "nobody." My problem is that the formula is based on info from another table, but I need it on that table.

Those are my examples of base:

I'm trying to add this formula field to the Report Table. Can someone help me? thank you!

[TheTimeSavingCo · Accepted solution]

Hmm, what if you put the formula inside a rollup of the status field? 

IF(
  FIND(
    "Inactive",
    ARRAYJOIN(values)
  ),
  "Not everyone",
  "OK"
)

Link to base

[Sara]

Thank you very much! it works perfectly!