Dear lovely people, I’m stuck with a formula (again). I have a base for coordination of translation work. I’d like to get an alert emoji if in a record: “activity” is “translation” and WC is empty or “activity” is “review, proofreading, upload” and “time task” is empty or “activity” is empty Do you know if this is possible to build in a formula field? Thanks so much in advance! :blush: Belén

Solved

Formula to identify records that need attention

Forum|Forum|5 years ago
April 21, 2020
2 replies
31 views

Belen_Bueso_Rio
New Participant

Dear lovely people,

I’m stuck with a formula (again). I have a base for coordination of translation work. I’d like to get an alert emoji if in a record:

“activity” is “translation” and WC is empty or
“activity” is “review, proofreading, upload” and “time task” is empty or
“activity” is empty

Do you know if this is possible to build in a formula field?

Thanks so much in advance! :blush:

Belén

Best answer by Mohamed_Swella1

Hi @Belen_Bueso_Rios,

Yes, definitely possible. Better yet, you can use the Colors or Views to do so.

If you want to use a formula, you can use the following:

IF(AND(Activity="translation",WC=BLANK()), "⚠️",
IF(AND(OR(Activity="review",Activity="proofreading",Activity="upload"),{Time Task}=Blank()), "⚠️",
IF(Activity=BLANK(),"⚠️")))

Let me know if that works as expected.

BR,
Mo

+17

Mohamed_Swella1
Inspiring
Answer
Forum|Forum|5 years ago
April 21, 2020

Hi @Belen_Bueso_Rios,

Yes, definitely possible. Better yet, you can use the Colors or Views to do so.

If you want to use a formula, you can use the following:

IF(AND(Activity="translation",WC=BLANK()), "⚠️",
IF(AND(OR(Activity="review",Activity="proofreading",Activity="upload"),{Time Task}=Blank()), "⚠️",
IF(Activity=BLANK(),"⚠️")))

Let me know if that works as expected.

BR,
Mo