How do you write the formula for Field A=X, Field B=Y therefore Field C=Z? I will need this for multiple scenarios. I want to calculate Field C based on A and B values.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of Vicki


  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
I think that you mean an IF statement.  They are similar to excel but simpler to write There is help info here

Here is an example of a formula text field.


[Field A] = "X" and [Field B] = "Y", "On Time", Late")