
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 21, 2020 03:53 AM
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! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 21, 2020 04:00 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 21, 2020 04:00 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 21, 2020 04:11 AM
Of course, colors! That works beautifully. You’re a genius. THANK YOU SO MUCH!!
Belén
