if criteria is met chose from two options

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I am trying to create a formula text field where on choices I would have either one result, or a possibility to chose from the two....the example is bellow:
Field name is: MT (example)
If ([FIELD 1] = "", "General",
If ([FIELD 2] = "", "Fluid",

and now the problematic criteria: If ([FIELD 3] = <>"", "Flexible" or "Optimized"
In other words if Field 3 is not blank, I should have a choice to select either Flexible or Optimized.

Is there a way to do that?
Photo of Nenad Ilic

Nenad Ilic

  • 734 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Formulas present a result and are going to be separate from data entry / data selection fields.  It sounds like your problem might be better solved with Form Rules, rather than a formula. 

I would set it up so that you would have a multiple choice drop-down for Flexible or Optimized and a formula similar to this:

 If ([FIELD 1] = "", "General",
If ([FIELD 2] = "", "Fluid",
If ([FIELD 3] <>"", [Drop-down Field],"")))

Then, I would setup a form rule that worked like this:

When [Field 3] is not blank, Require [Drop-down Field]