Skip to main content

Hello! I’m trying to write a “Deadline Alert” formula to indicate that a particular task is 🚨 PAST DUE​🚨or ❎ which means on track / not overdue. The conditions for a past due task are as follows:


(1) The field “Task Status” (Single Select Field) must NOT be set to “Complete” or “Not Started”---- completed or not started tasks can’t be past due :winking_face:

(2) The field “Approval Deadline” must be TRUE aka not blank

(3) The field “Days Past Due” (which already has a formula in it to calculate days past the approval deadline using DATETIME_DIFF) must be <1 (a negative number).


Below is my poor attempt that has not been working. I’m new to formulas and greatly appreciate the help!


IF(AND(

{Approval Deadline}=TRUE,

{Days Past Due}=<1,

{Task Status}!=(“Complete”,“Not Started”)

),

” 🚨 PAST DUE​🚨",

“ ❎ ”)

Try


IF(

    AND(

        {Approval Deadline},

        NOT(

            OR(

                {Task Status}='Complete',

                {Task Status}='Not Started'

                )

            ),

        {Days Past Due}<1

        ),

    '🚨',

    '❎'

    )

That will seemingly show a flashing light if today is the deadline — {Days Past Due} = 0 — so you may need to change the last comparison to {Days Past Due}<0, depending on the formula for {Days Past Due}.

This worked! Thank you very much @W_Vann_Hall

Reply


Terms & Conditions