Hello,

I'm trying to create a mapping using IF and OR statement, in order to map a set of values for the 'Status' field to this new formula field.  This formula doesn't cause an errors, but it only partially works.  Does anyone know why this doesn't work?

IF(
{Status} = "Complete",
  "Completed",
  IF(
    OR(
      {Status} = "Low Risk",
      {Status} = "Candidate"
    ),
    "On track",
    IF(
      OR(
        {Status} = "Medium Risk",
        {Status} = "High Risk",
      ),
      "At risk",
      IF(
        OR(
          {Status} = "New",
          {Status} = "Needs Investigation",
          {Status} = "Need More Info",
          {Status} = "Under Review",
          {Status} = "On Hold",
          {Status} = "Deferred"
        ),
        {Status} = "Delayed",
        IF(
          {Status} = "Will Not Implement",
          "Will not implement",
          ""
        )
      )
    )
  )
)

 The following inputs work, but the others do not: Complete, Low Risk, & Will Not Implement

Thank you.