Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Help with Flagging Overdue or At-Risk Tasks

Topic Labels: Formulas
Solved
Jump to Solution
1360 3
cancel
Showing results for 
Search instead for 
Did you mean: 
ellllllllllle
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a formula that is achieving 2/3 of my goals, but I need some help figuring out that last 1/3! I am trying to add an "SOS" flag to any to-do that meets one or more of the following criteria:

  1. Has been manually flagged as "Behind" in the Alerts column.
  2. Has not been given a Due Date (so the Due Date field is blank).
  3. Has a Due Date that has passed AND it has NOT yet been marked as "Done."

How would I structure that final part of the formula? Currently, I have:

 
IF(
     OR(
          Alerts = "Behind",
          {Due In} < 1
     ),
          "🆘",
          ""
)

I am trying to get the "Post job description on social media" task to be flagged, since it is overdue and not marked as done.

Thank you so much! 
 
Untitled.jpg

 

1 Solution

Accepted Solutions
CJSmith
7 - App Architect
7 - App Architect

Hi @ellllllllllle, the last component to your OR() clause should be as follows:

AND(DATETIME_DIFF({Due Date}, TODAY(), 'days')<0, {Status}!="Done")

Altogether, the formula should look like this:

IF(
  OR(
    {Alerts}="Behind", 
    {Due In}<1, 
    AND(DATETIME_DIFF({Due Date}, TODAY(), 'days')<0, {Status}!="Done")), 
  "🆘", "")

Let me know if that works!

See Solution in Thread

3 Replies 3
CJSmith
7 - App Architect
7 - App Architect

Hi @ellllllllllle, the last component to your OR() clause should be as follows:

AND(DATETIME_DIFF({Due Date}, TODAY(), 'days')<0, {Status}!="Done")

Altogether, the formula should look like this:

IF(
  OR(
    {Alerts}="Behind", 
    {Due In}<1, 
    AND(DATETIME_DIFF({Due Date}, TODAY(), 'days')<0, {Status}!="Done")), 
  "🆘", "")

Let me know if that works!

ellllllllllle
5 - Automation Enthusiast
5 - Automation Enthusiast

@CJSmith It worked, thank you so much!

CJSmith
7 - App Architect
7 - App Architect

You got it!