Discussions

Expand all | Collapse all

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

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

    Posted 08-28-2018 22:58
    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.


  • 2.  RE: I would like to create a column that references two other columns

    Posted 08-28-2018 23:08
    This is assuming Column One is a Text field.

    If(
    [Column1]="Yes",[Column2]
    )


  • 3.  RE: I would like to create a column that references two other columns

    Posted 09-04-2018 13:19
    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.



  • 4.  RE: I would like to create a column that references two other columns

    Posted 09-04-2018 13:26
    One of my system admins created the column for me.  I'm not quite sure how she did it.


  • 5.  RE: I would like to create a column that references two other columns

    Posted 09-04-2018 16:51
    Change "Yes" to TRUE

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

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