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

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
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.
Photo of Colin Madden

Colin Madden

  • 92 Points 75 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Photo of dwhawe

dwhawe, Champion

  • 662 Points 500 badge 2x thumb
This is assuming Column One is a Text field.

If(
[Column1]="Yes",[Column2]
)
(Edited)
Photo of Colin Madden

Colin Madden

  • 92 Points 75 badge 2x thumb
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.

Photo of Colin Madden

Colin Madden

  • 92 Points 75 badge 2x thumb
One of my system admins created the column for me.  I'm not quite sure how she did it.
Photo of dwhawe

dwhawe, Champion

  • 662 Points 500 badge 2x thumb
Change "Yes" to TRUE

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

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