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

Question

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.

davidhawe · Answer

This is assuming Column One is a Text field.If([Column1]="Yes",[Column2])

colinmadden · Answer

Thanks for your help.&nbsp; I got the following error:&nbsp;The expression&nbsp;[Linedown]&nbsp;on the left hand side of the operator "=" is of type&nbsp;bool&nbsp;while the expression&nbsp;"Yes"&nbsp;on the right hand side is of type&nbsp;text. The operator "=" cannot be used with these types of expressions.

colinmadden · Answer

One of my system admins created the column for me.&nbsp; I'm not quite sure how she did it.

davidhawe · Answer

Change "Yes" to TRUEWithout Quotes.&nbsp; "Yes" is text and TRUE is BoolIf([Column1]=TRUE,[Column2])

Forum Discussion

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

Related Content

Reference tables quandary

Tracking References and Definitions

Default column widths on embedded reports obscuring data

Reference Numbers Displaying Instead of Names in QuickBase

Rearrange Fields/Columns in table