Help

IF Clause formula based on different table

Topic Labels: Formulas
Solved
Jump to Solution
191 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sara
8 - Airtable Astronomer
8 - Airtable Astronomer

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:

Sara_0-1709646614297.png

Sara_1-1709646795322.png

 

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

 

 

1 Solution

Accepted Solutions
TheTimeSavingCo
17 - Neptune
17 - Neptune

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

 

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

 

Screenshot 2024-03-05 at 10.24.14 PM.png

Screenshot 2024-03-05 at 10.25.39 PM.png

Link to base

See Solution in Thread

2 Replies 2
TheTimeSavingCo
17 - Neptune
17 - Neptune

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

 

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

 

Screenshot 2024-03-05 at 10.24.14 PM.png

Screenshot 2024-03-05 at 10.25.39 PM.png

Link to base

Thank you very much! it works perfectly!