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.

Multiple If Statements Based on Multiple Data Points

Topic Labels: Formulas
971 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Scott_Belgard
4 - Data Explorer
4 - Data Explorer

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 “ :heavy_check_mark: Less Than 3 Days :heavy_check_mark: ”
If it is not, then if “Days Since Contact” is <5 then return “ :warning: Almost More than 5 Days :warning: ”
If it is not, then if “Days Since Contact” is >5 and Status Does Not = Revisit Later then “ :x: Greater Than 5 Days :x: ”
If Status = “Revisit Later” and “Days Since Contact” is >30 then :x: Time To Revisit :x:
If not then leave blank.

2022-05-24_15-20-58

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

1 Reply 1
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.