Discussions

 View Only
  • 1.  if criteria is met chose from two options

    Posted 11-15-2017 11:29
    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?


  • 2.  RE: if criteria is met chose from two options

    Posted 11-15-2017 18:21
    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]