Forum Discussion
Creating a custom column with multiple TRUE responses
Anonymous
If you can use the following method as well in a new custom column, it evaluates to True when both the columns are true:[Column1] and [Column2]Hi Anonymous ,
I think this is probably due to your column formats. I've assumed they are text format as your example stated "true" as the condition.
If the columns to be evaluated are actually boolean data type, then you can use the shortcut that Fowmy has suggested, something like this:
if [Column1] or [Column2] then "true" else "false"The above will output text values. If you want to output actual boolean type, then just remove the quote marks from the output values:
if [Column1] or [Column2] then true else falsePete
Thank BA_Pete - the syntax works, but all results appear false when I'm expecting most to be true. I've been mindful of case sensitivity and checked both ways but the same problem persists.
Hi Anonymous ,
I think this is probably due to your column formats. I've assumed they are text format as your example stated "true" as the condition.
If the columns to be evaluated are actually boolean data type, then you can use the shortcut that Fowmy has suggested, something like this:
if [Column1] or [Column2] then "true"
else "false"
The above will output text values. If you want to output actual boolean type, then just remove the quote marks from the output values:
if [Column1] or [Column2] then true
else false
Pete