Value of A, or value of B if A is empty
- What is it? 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
-
If field A has a value, this is the result.
-
If not, field B's value is the result.