Forum Discussion

ColinMadden's avatar
ColinMadden
Qrew Trainee
7 years ago

I would like to create a column that references two other columns

I would like to create a column that references two other columns; the first column can only contain yes or no. If it is a yes, I would like to display the contents of the second column.
Formulas and functions
ColinMadden's avatar
ColinMadden
Qrew Trainee
7 years ago
Thanks for your help.  I got the following error: The expression [Linedown] on the left hand side of the operator "=" is of type bool while the expression "Yes" on the right hand side is of type text. The operator "=" cannot be used with these types of expressions.

DavidHawe's avatar
DavidHawe
Qrew Trainee
7 years ago
Change "Yes" to TRUE

Without Quotes.  "Yes" is text and TRUE is Bool

If(
[Column1]=TRUE,[Column2]
)