Skip to main content
SharePoint

Return to Question

Formatted Formula
Source Link
theChrisKent
theChrisKent
  • 6.1k
  • 22
  • 34

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",""))

=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",
      ""
    )
  )

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",""))

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",
      ""
    )
  )
Source Link
user63270
user63270
  • 189
  • 9

SharePoint Calculated Field Limitation?

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",""))