Skip to main content
Question

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.
    This topic has been closed for replies.

    • DavidHawe
    • Registered
    • August 29, 2018
    This is assuming Column One is a Text field.

    If(
    [Column1]="Yes",[Column2]
    )
    • ColinMadden
    • Author
    • Registered
    • September 4, 2018
    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.

    Terms & ConditionsAccessibility statement