+16Hi 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!
Best answer by TheTimeSavingCo
Hmm, what if you put the formula inside a rollup of the status field?
IF(
FIND(
"Inactive",
ARRAYJOIN(values)
),
"Not everyone",
"OK"
)
+31Hmm, what if you put the formula inside a rollup of the status field?
IF(
FIND(
"Inactive",
ARRAYJOIN(values)
),
"Not everyone",
"OK"
)
+16Hmm, what if you put the formula inside a rollup of the status field?
IF(
FIND(
"Inactive",
ARRAYJOIN(values)
),
"Not everyone",
"OK"
)
Thank you very much! it works perfectly!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.