Skip to main content

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!

 

 

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

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


Thank you very much! it works perfectly! 

Reply


Terms & Conditions