Discussions

Expand all | Collapse all

How would I go about automating a current ""if"" statement ?

  • 1.  How would I go about automating a current ""if"" statement ?

    Posted 02-21-2018 21:30

    I currently have a Formula-Text field with 10 true statements, and now I want to automate it when any 5 of the 10 true statements occur I want to change Field-X output from Y to a Z.


    Any suggestion on how to make this happen?



  • 2.  RE: How would I go about automating a current ""if"" statement ?

    Posted 02-21-2018 21:35
    if(count(
    [field 1],
    [field 2]
    ...

    [field 10]) > 5, "say this", else say that")