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

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered

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?

Photo of Stephen Anguiano

Stephen Anguiano

  • 394 Points 250 badge 2x thumb

Posted 10 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
if(count(
[field 1],
[field 2]
...

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