1

On a calculated field is there any limit on the number of conditions? I have the following but it does not seem to be producing accurate results..

=IF(
  OR([funnel status]="Early Engagement (Active)",[funnel status]="Early Engagement (Non-Active)",[funnel status]="DRFP (Active)",[funnel status]="DRFP (Non-Active)",[funnel status]="Post Proposal Submission"),
  "active",
    IF(
      OR([funnel status]="DRFP Question",[funnel status]="RFI",[funnel status]="RFP",[funnel status]="BAFO",[funnel status]="Orals Prep",[funnel status]="Orals",[funnel status]="Quals",[funnel status]="ENs",[funnel status]="FRP",[funnel status]="Bridge",[funnel status]="Contract MOD",[funnel status]="unsolicited"),
      "live",
      ""
    )
  )
1

In answer to your question about limits, the OR function has a limit of 30 conditions, but that shouldn't be causing you a problem in this case.

Try switching your formula to this:

=IF(
  OR(EXACT([funnel status],"Early Engagement (Active)"),
     EXACT([funnel status],"Early Engagement (Non-Active)"),
     EXACT([funnel status],"DRFP (Active)"),
     EXACT([funnel status],"DRFP (Non-Active)"),
     EXACT([funnel status],"Post Proposal Submission")),
  "active",
  IF(
    OR(EXACT([funnel status],"DRFP Question"),
       EXACT([funnel status],"RFI"),
       EXACT([funnel status],"RFP"),
       EXACT([funnel status],"BAFO"),
       EXACT([funnel status],"Orals Prep"),
       EXACT([funnel status],"Orals"),
       EXACT([funnel status],"Quals"),
       EXACT([funnel status],"ENs"),
       EXACT([funnel status],"FRP"),
       EXACT([funnel status],"Bridge"),
       EXACT([funnel status],"Contract MOD"),
       EXACT([funnel status],"unsolicited")),
    "live",
    ""
  )
)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.