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

4 Replies

Related Content

Report Column labels not saving

Multiple reference proxy fields help

Same reference field, different selections within the form

Create a formula duration over 5 years

Create a Comparison Column in Summary Reports

Recent Discussions

Share your feedback on the new Qrew Discussions

Generating QR Code with URL to record

Disappearing Native Tool Bar on Mobile

Time of Day field values are not in 24-hour format in Pipelines

Copied Field doesn't have the same usage as the original