I currently have 2 entity lists (identical), and a module which maps the entity 1 list to entity 2 list. What I'm trying to do is to create a matrix with entity 1 as rows, and entity 2 in the columns (i.e. an entity matrix).
1. How do I create a formula which states if Entity in row = Entity in the column, select boolean?
There is another potential solution to this requirement. If you had a module which is dimensioned by Entity 1 and you wanted to find all the corresponding Entity 2 records (or vice versa), you could do this using the finditem function.
In your entity 1 module you would add a line item which is list formatted as Entity 2. Then use the formula: