Forum Discussion

ColinMadden's avatar
ColinMadden
Qrew Trainee
6 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
6 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.

  • ColinMadden's avatar
    ColinMadden
    Qrew Trainee
    6 years ago
    One of my system admins created the column for me.  I'm not quite sure how she did it.
  • DavidHawe's avatar
    DavidHawe
    Qrew Trainee
    6 years ago
    Change "Yes" to TRUE

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

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