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

Vicki

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 62,994 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 http://www.quickbase.com/user-assistance/Default.html#using_formulas_in_QuickBase.html

Here is an example of a formula text field.

IF(

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