Skip to main content

I have tried multiple Nested If statements to achieve this result:


This is my ultimate goal:


If “Date of Last Contact” is blank then return blank.

If it is not, then if “Days Since Contact” is ❤ then return “ ✔ Less Than 3 Days ✔ ”

If it is not, then if “Days Since Contact” is <5 then return “ ⚠ Almost More than 5 Days ⚠ ”

If it is not, then if “Days Since Contact” is >5 and Status Does Not = Revisit Later then “ ❌ Greater Than 5 Days ❌ ”

If Status = “Revisit Later” and “Days Since Contact” is >30 then ❌ Time To Revisit ❌

If not then leave blank.



IF({Date of Last Contact} = BLANK(),BLANK(),IF({Days Since Contact}<=3,“ ✔ Less Than 3 Days ✔ ”,IF({Days Since Contact}<=5,“ ⚠ Almost More than 5 Days ⚠ ”, IF(AND({Days Since Contact}>5,{Status}NOT(“Revisit Later”), “ ❌ Greater Than 5 Days ❌ ”, IF(AND({Status} = “Revisit Later”, {Days Since Contact}<30, BLANK(),IF (AND({Status}=“Revisit Later”, {Days Since Contact}>30,“ ❌ Time To Revisit ❌ ” ))))))))

IF(

  {Date of Last Contact},

  IF(

    {Days Since Last Contact} < 3,

    "Less than 3",

    IF(

      {Days Since Last Contact} < 5,

      "Almost More than 5 Days",

      IF(

        AND(

          {Days Since Last Contact} > 5,

          {Status} != "Revisit Later"

        ),

        "Greater Than 5 Days",

        IF(

          AND(

            {Days Since Last Contact} > 30,

            {Status} = "Revisit Later"

          ),

          "Time to revisit"

        )

      )

    )

  )

)

Note: the field will show nothing if its been exactly 5 days since last contact.

Reply


Terms & Conditions