Predefined Calculation: Value of A, or value of B if A is empty

Summary

This formula can be used to provide a fallback value if a question is not answered. It is particularly useful when working with internal only fields - if A is internal only, B will be the result of the formula on website submissions.

Inputs

This formula requires 2 inputs:

  • Field A - this value will be returned if it is present e.g the question was answered.
  • Field B - this will be returned if field A is empty for the submission.

Return values

This formula returns:

Value Description
Value of Field A If Field A has a value e.g. was answered.
Value of Field B If Field A is empty.

Formula Logic

  1. If field A has a value, this is the result.

  2. If not, field B's value is the result.

results matching ""

    No results matching ""