Skip to main content
Question

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

  • Aug 29, 2018 2:58 AM UTC
  • 0 replies
  • 211 views

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.

  • Qrew Cadet
  • Aug 29, 2018 3:08 AM UTC
This is assuming Column One is a Text field.

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

  • Author
  • Qrew Member
  • Sep 4, 2018 5:19 PM UTC
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.